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