sumif with multiple sums

[Shi Gharib]

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]

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]

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

 

[Shi Gharib]

It was verry helpful thank u
--
Shi Gharib

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

--
__________________________________
HTH

Bob