Using SUMIF with AND

T

Tailgator

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

Henry

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF by Week. 8
Looping through permutations 7
Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
Tracking using =sumproduct 3
Sum data using sumif 3
Cross refrence an index table and sum in one step? 7
Excel - Wich Function should I use? 1

Top