Thread: How do I set up a nested SUMIF formula for a number of variables?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nancy
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote