Sumif with 2 criteria

Giganews Newsgroups
Subject: Sumif with 2 criteria
Posted by:  Mike
Date: Tue, 16 May 2006

Okay, I've done my research, but I can't find the answer to this... I want to
do a sumif with two different criteria, each criteria is in a different
column (like a category, then a sub-category).  I've tried the
sumproduct(--..., but I couldn't make it work.

Each number is attached to a category and sub category:

Auto    Gas            130
Auto    Insurance  25
Food    Groceries  200
Auto    Insurance  50

So, this is what i've tried:  =sumif(a1:b4,and("Auto","Insurance"),c1:c4)

Please help!

Replies