Learn the powerful SUMIF Function

Here are the steps to follow in this lesson:

1. Type =sumif( and then click the FUNCTION WIZARD to enter the ARGUMENTS.
2. Enter the range of data that you wish to SUM as the 1st Argument.
3. Identify the Criteria to evaluate e.g. “>500″ – (enclose the Argument inside ” “) as the 2nd Argument.
4. The 3rd Argument is OPTIONAL. You can leave this empty if you want to SUM the same range of data from your 1st Argument.

NEW! Download the Practice File from this Lesson:

• sumif-function

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Videos

• Use the =SUMIF() Function to Total YTD Sales
  
• 3 reasons to use named cells and ranges in your Excel formulas