sumif with 2 variables

D

Dave

i want to create a formulae to sum a range of numbers in a column providing
two conditions are met in other columns.

I can do it using SUMIF for one condition ie. SUMIF(A14:A401,R5,B14:B401)

but how do you add in a second criteria to also be met before the cells
B14:B401 are added

something like SUMIF(A14:A401,R5 and C14:C401,T6 then sum B14:B401)
 
B

Bob Phillips

=SUMPRODUCT(--(A14:A401=R5),--(C14:C401=T6),B14:B401)

If you have Excel 2007, you can use SUMIFS

=SUMIFS(B14:B401,A14:A401,R5,C14:C401,T6)
 

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 formula 4
SUMIF with multiple conditions 5
SUMIF with criteria "<>" & "=" 4
sumif wildcard for text and numbers 5
SumIF with 2 Conditions 3
Using SUMIF with AND 2
Sumif number is greater than a number but less than another number 2
sumif with 2 criteria? 11

Top