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
Tracking using =sumproduct 3
Cross refrence an index table and sum in one step? 7
a "SUMIF" question 1
Please help with countif formula 4
Sumif less than x 3
sumif with 2 variables 2

Top