software

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?

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)

quot;Nancyquot; wrote:

gt; I am working in Excel 2000 to create a nested SUMIF Formula.
gt; If the values in Column A equal a set value and the values in Column B equal
gt; a set value, then sum Column C. Columns A and B are text columns and Column
gt; C is numeric.
gt;
gt; I have typed
gt; SUMIF(A4:A147,A150,SUMIF(B4:B147,B150,C4:C147))
gt; and I continue to get errors.
gt;
gt; I only have Excel 2000.
gt;
gt; Any suggestions?

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

quot;Nancyquot; gt; wrote in message
...
gt;I am working in Excel 2000 to create a nested SUMIF Formula.
gt; If the values in Column A equal a set value and the values in Column B
gt; equal
gt; a set value, then sum Column C. Columns A and B are text columns and
gt; Column
gt; C is numeric.
gt;
gt; I have typed
gt; SUMIF(A4:A147,A150,SUMIF(B4:B147,B150,C4:C147))
gt; and I continue to get errors.
gt;
gt; I only have Excel 2000.
gt;
gt; Any suggestions?