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. |
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 |