Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Multiple SUMIF Criteria | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |