=sumproduct((A1:A100="category")*(B1:B100="unplann ed")*C1:C100)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tailgator" wrote in message
...
I'm trying to create a formula to sum a range of numbers if two conditions
are true.

Please help.

Is there a way to do the following in a cell using a SUMIF
IF (A1:A100,"category") AND (B1:B100, "unplanned") then add C1:C100

Thank you.