| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use 3 separate column qualifiers to sum? IF statements?
I am trying use 3 columns, from another tab, as qualifiers to obtain sum.
Example, look at column A for all 1s, look at column B for all the "0"s and look column C for all the "1"s. From those qualifiers, obtain a sum. I have tried to use a "Sum" statement with IF embedded in the formula, but I get the message "too many arguments for this function. I would appreciate if anybody can help me. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use 3 separate column qualifiers to sum? IF statements?
Assume the values you want to sum are located in column D:
=SUMPRODUCT(--(A1:A100=1),--(B1:B100=0),--(C1:C100=1),D1:D100) -- Regards, Dave "Shahbaze" wrote: I am trying use 3 columns, from another tab, as qualifiers to obtain sum. Example, look at column A for all 1s, look at column B for all the "0"s and look column C for all the "1"s. From those qualifiers, obtain a sum. I have tried to use a "Sum" statement with IF embedded in the formula, but I get the message "too many arguments for this function. I would appreciate if anybody can help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print separate reports with same column heading | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
