View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Two conditions in a SUMIF function

I am trying to sum a list of numbers but I have two different critia that I
need sorted by. One is week number and the other is Camp Name.

So for the following

Money Week Camp
200 2 Teen
250 1 Teen
320 2 Rock

I would like to be able to input sum money if colume B=1 and C=Teen and
return 200 instead of 450 or 520.

If anyone knows how do that this a little help would be great