Excel: How to Use the Database Functions DSUM, DAVERAGE, DMAX and DMIN

Excel has some useful database functions that allow you to set criteria so that you can filter information in a list or database so that you can sum, average, and get highest and lowest values. These are done using the functions DSUM, DAVERAGE, DMAX and DMIN. Gary Schwartz from http://www.jargonfreehelp.com shows us how.

This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0

For more tutorials see my website http://www.jargonfreehelp.com

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

• #science_technology
• #d_functions
• #dsum
• #daverage
• #dmax
• #dmin
• #ecdl
• #excel
• #microsoft_excel
• #microsoft_365
• #office_365
• #excel_tip
• #excel_trick
• #learn_excel
• #how_to_excel
• #database
• #excel_database
• #database_functions