Home
MS Office - How to ?
Win Vista Training
Windows 7 Tutorials
Excel Tutorials
Word Tutorials
PowerPoint Tutorials
Outlook Tutorials
Excel 2007 Tutorials
Word 2007 Tutorials
PowerPoint 2007 Tutorials
Office 2007 Training
Office 2007 Videos
Free E-Books
Free Templates
Free Clip Arts
Tips and Tricks
Office 2010 Tips
Google Docs and ...
MS Office Software
MS Publisher
Site Map
Contact Us
Resources Page

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines
 


Use the 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.


To use the SUMIF function (example)

  • Create a worksheet as shown below:

    excel worksheet


    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.

    Insert Function - SUMIF


  • From the Insert Function dialog box displayed, under the Search for a function: box, type in sumif and click the Go button.
  • 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.

    SUMIF Function Arguments


  • 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)

    SUMIF Function Arguments


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


    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    << Previous Topic : Changing and Customizing the Excel 2003 Styles


    You're viewing the Excel SUMIF function info page, click here to go back to the Home Page


    footer for sumif function page

    		•