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:

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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn


  1. […] Taught” under the Menu on my home page. The index allow you to click on a specific topic e.g. “=SUMIF” and go directly to that […]

Speak Your Mind