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 with multiple conditions 5
Nesting SUMIF 3
SUMIF by Week. 8
Using SUMIF with AND 2
SumIF with 2 Conditions 6
Real-time sorting 11
SUMIF-how do i get it to work using names in range?help 3
SumIf with multiple Criteria 6

Top