Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Reply
Views: 981 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rate Thread Display Modes
  #1  
Old 01-26-2010, 11:53 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default Topic 35: Use the Excel SUMIF Function Correctly!

In Excel 2003, the SUMIF function adds all numbers in a range of cells, based on a given criteria.

Sometimes you may need to use only certain values inside a range in a summation, based on a defined condition. Using Microsoft Excel 2003, this can be calculated with the SUMIF function.

The SUMIF function can also use another range of cells to determine whether or not the condition is met.

The syntax for the SUMIF function is:
=SUMIF(range,criteria,sum_range)

range is the range of cells you want to evaluate (apply the criteria against).
criteria is the criterion you want to meet to evaluate the number.
sum_range are the numbers you want to actually sum.

Reply With Quote
  #2  
Old 01-26-2010, 11:54 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default

To use the SUMIF function (example)

Create a worksheet as shown below:


Now, we will use this worksheet to calculate the Smith’s total sales.Click on the cell B10, the cell that will displays the result.
From the Insert menu, click on Function.


From the Insert Function dialog box displayed, under the Search for a function: box, type in sumif and click the Go ****on.
In the Select a function: box, make sure you select the SUMIF and click OK.

From the Function Arguments dialog box displayed, do the followings:

Range: Select or type in A2:A8 as we want to evaluate within this ranges that contains the name Smith’s.

Criteria:
Type in Smith.
Sum_range: Select or type in B2: B8 as this is the ranges that we want to add up the total sales by Smith’s.
Reply With Quote
  #3  
Old 01-26-2010, 11:56 AM
seema seema is offline
Administrator
 
Join Date:
Oct 2009
Posts: 5,551
Default


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
Reply

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.