Thread: Topic 35: Use the Excel SUMIF Function Correctly!
View Single Post
  #3  
Old 01-26-2010, 11:56 AM
seema seema is offline
Administrator
  
Join Date: Oct 2009
Posts: 5,409

Click OK. This produces the result 85450. That is 35200+22100+28150.Note: To find the sum of the sales that exceed 30000, use this function:
=SUMIF(B8:B8,>30000)



This produces the result 100700 (35200+22100+28150).
Reply With Quote