View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan B[_2_] Dan B[_2_] is offline
external usenet poster
 
Posts: 6
Default Need Sumif help....

Here are my formulas:
=SUMIF(D3:D33,"<8",D3:D33)
=SUMIF(D4:D34,"8",D4:D34)

I need to edit these to only sum the amounts that are over or under 8. For
example, for the first formula, if there were 3 cells in this range that had
the value of 5, then the result of the formula should show 9. For the
second formula...;if there were 2 cells with the valud of 10 the result
would show 4.

I think I need to use MIN in there somewhere, but I'm not sure how.

Thanks.