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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a nested SUMIF formula for a number of variables?
For multiple conditions on different variables, you'll need to use
SUMPRODUCT, where the arguments are two true/false arrays and one of the variable you want to add. Something like =sumproduct(--(a4:a147 = a150),--(b4:b147 = b150), c4:c147) "Nancy" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a nested SUMIF formula for a number of variables?
Tell us what your really need to find. I think a SUMPRODUCT formula is
called for. Let us have more detail. You want to sum A4:A147 subject to what criteria? best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Nancy" wrote in message ... 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? |
Reply |
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) |