| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a nested SUMIF formula for a number of variables?
I am working in Excel 2000 to create a nested SUMIF Formula.
If the values in Column A equal a set value and the values in Column B equal a set value, then sum Column C. Columns A and B are text columns and Column C is numeric. I have typed SUMIF(A4:A147,A150,SUMIF(B4:B147,B150,C4:C147)) and I continue to get errors. I only have Excel 2000. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to determine number of Standard Deviations based on % of population | Excel Worksheet Functions | |||
| formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
| Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
Threaded Mode
