sumif with 2 variables
 

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)

sumif with 2 variables
 

=SUMPRODUCT((A14:A401=R5)*(C14:C401=T6)*B14:B401)
--
David Biddulph

"Dave" wrote in message
...
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)

sumif with 2 variables
 

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


--
__________________________________
HTH

Bob

"Dave" wrote in message
...
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)

sumif with 2 variables
 

Thanx David,
spot on.

"David Biddulph" wrote:

=SUMPRODUCT((A14:A401=R5)*(C14:C401=T6)*B14:B401)
--
David Biddulph

"Dave" wrote in message
...
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)