Excel SUMIFS Sum With Multiple Criteria

from contextures.com

Excel SUMIFS Sum With Multiple Criteria:

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 status is Active, and the number of visits is greater than or equal to 10. You can type in the criteria, but it's better to use cell references, where possible.

I've updated the Excel SUM page on the Contextures website, to include the SUMIFS function example and video.

Watch the SUMIFS Video

To see the steps for creating a SUMIFS formula, and using cell reference, you can watch this short Excel video tutorial.

Or watch on YouTube: Excel SUMIFS Sum With Multiple Criteria

_____________

RSS Footer: Thank you for subscribing to the RSS feed for Contextures Blog .

You can read the full article here: Excel SUMIFS Sum With Multiple Criteria

Please visit the Contextures page on Facebook