Sumif with 2 criteria
You could also use the DSUM function if you set up your data with headings
and set up a separate table for the criteria (2 rows inc headings and as
many columns as you have criteria)
Hopefully the named ranges in this example are self explnatory
=DSUM(Tbl_With_Heads,3,Crit)
;-)
"Mike" wrote in message
...
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!
|