How do I set up a nested SUMIF formula for a number of variables?

[Guest]

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?

 

[Guest]

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)

 

[Bernard Liengme]

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