Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a Lookup/Sumif Combo Formula
I have 4 columns that contain amounts which can be the same in all four
columns, they can be different and can also be blank. If they are the same, I want the amount only once but if they are different, I want to sum only the amounts that are different. Blank cells can be ignored. A B C D 500.00 500.00 500.00 = this would return value of 500.00 100.00 100.00 200.00 200.00 = this would return value of 300.00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a Lookup/Sumif Combo Formula
=SUMPRODUCT((A1:D1<"")/COUNTIF(A1:D1,A1:D1&""),A1:D1)
"LSully" wrote: I have 4 columns that contain amounts which can be the same in all four columns, they can be different and can also be blank. If they are the same, I want the amount only once but if they are different, I want to sum only the amounts that are different. Blank cells can be ignored. A B C D 500.00 500.00 500.00 = this would return value of 500.00 100.00 100.00 200.00 200.00 = this would return value of 300.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation combo box lookup | Excel Worksheet Functions | |||
How do i combine a lookup and a sumif formula? | Excel Discussion (Misc queries) | |||
combo boxes and lookup | New Users to Excel | |||
sumif? lookup? | Excel Worksheet Functions | |||
Help with SUMIF, INDEX, LOOKUP Please !! | Excel Worksheet Functions |