Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple sums
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 -- Shi Gharib |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple sums
Hi,
You can use a simple IF() function here =if(A1="Name",B1-C1-D1,"") -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Shi Gharib" wrote in message ... 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 -- Shi Gharib |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple sums
=SUMPRODUCT(--(A2:A20="some_value"),B2:B20-C2:C20-D2:D20)
-- __________________________________ HTH Bob "Shi Gharib" wrote in message ... 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 -- Shi Gharib |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif with multiple sums
It was verry helpful thank u
-- Shi Gharib "Bob Phillips" wrote: =SUMPRODUCT(--(A2:A20="some_value"),B2:B20-C2:C20-D2:D20) -- __________________________________ HTH Bob "Shi Gharib" wrote in message ... 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 -- Shi Gharib |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
conditional sums and multiple criteria | New Users to Excel | |||
adding multiple sums w/ different criteria | Excel Discussion (Misc queries) | |||
multiple entries-sums to different cells | Excel Worksheet Functions | |||
Excell will not add multiple sums together, what do I have turned. | Excel Discussion (Misc queries) |