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