sumif with multiple sums

Shi Gharib · Oct 30, 2008

hi,
I need to use the SUMIF or the SUMPRODUCT functions with multiple sums. for
example : if I have 4 columns A, B, C, D i want a formula that calculates B
minus C minus D if Column A matches certain name or value

thanks in advance

Ashish Mathur · Oct 30, 2008

Hi,

You can use a simple IF() function here

=if(A1="Name",B1-C1-D1,"")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

Bob Phillips · Oct 30, 2008

=SUMPRODUCT(--(A2:A20="some_value"),B2:B20-C2:C20-D2

20)

Shi Gharib · Oct 30, 2008

It was verry helpful thank u
--
Shi Gharib

Bob Phillips said:
=SUMPRODUCT(--(A2:A20="some_value"),B2:B20-C2:C20-D220)

--
__________________________________
HTH

Bob