Excel SUMIFS Sum With Multiple Criteria

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,005
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jan 27, 2012

http://www.contextures.com/xlfunctions01.html In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria.
For example, sum the orders where an account is Active, and the quantity is greater than or equal to 10.

This video shows the steps for using the SUMIFS function, and using cell references instead of hard coded values.

Link to this comment:

Share to:

Uploader Comments (contextures)

  • Thanks Debra

  • @krn14242 You're welcome, and thanks for your comment. Hope you can find a use for SUMIFS

see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • Thanks for showing this function off!

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more