The SUMIFS and DSUM Functions use Multiple Criteria in Excel
The new SUMIFS() Function was introduced in Excel 2007. SUMIFS allows you to sum the values in one field based on matching criteria from two or more fields.
Very valuable!
However, if you are using Excel 2003 or older. Or, if you need to share workbooks with clients using Excel 2003 or older, you can use the DSUM() Funtion to produce the same results as SUMIFS.
As a bonus, on this lesson, I show you how to use Data Validation to select criteria from a drop-down menu list.
Please visit my secure, online shopping website - http://shop.thecompanyrocks.com - to learn about the products that I offer for sale.
Danny Rocks
The Company Rocks