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
Watch video The SUMIFS and DSUM Functions use Multiple Criteria in Excel online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 04 December 2011, don't forget to share it with your friends and acquaintances, it has been viewed on our site 95,576 once and liked it 165 people.