Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function help
Hi,
I posted a problem concerning the SUMIF formula yesterday. The problem has slighly changed. I want the SUMIF formula to add the values in KolA only if the sum of KolA-(KolB + KolC) is greater then 0. The comparison is to be down for each row. If I, for example, have the following numbers: Kol A Kol B KolC 100 25 30 60 40 30 25 20 15 In the above example the SUMIF formula should return 85. I need to use the SUMIF formula since the result should only be calculated for rows not hidden by the autofilter function. Regards PO |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function help
responded to it.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "PO" <h wrote in message ... Hi, I posted a problem concerning the SUMIF formula yesterday. The problem has slighly changed. I want the SUMIF formula to add the values in KolA only if the sum of KolA-(KolB + KolC) is greater then 0. The comparison is to be down for each row. If I, for example, have the following numbers: Kol A Kol B KolC 100 25 30 60 40 30 25 20 15 In the above example the SUMIF formula should return 85. I need to use the SUMIF formula since the result should only be calculated for rows not hidden by the autofilter function. Regards PO |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |