Using SUMIF with AND
 

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.

Using SUMIF with AND
 

=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.

Using SUMIF with AND
 

If you are using 2007, you can use the SUMIFS function. If not then I suggest
Concatenate colums A&B and do your SUMIF based on that.

Henry

"Tailgator" wrote:

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.