DSUM of all things

September 15, 2020

Today’s Data Hack takes you back to basics to make the most out of Excel. You don’t need to be a scientist in order to sort and analyze data in a basic way. Check out this short overview of database functions that will help you parse information from lists:

DCOUNT – Count the number of cells with values

DMAX – Finds the largest value in a list

DMIN – Finds the smallest value in a list

DSUM – Calculate the sum of values matching criteria

These functions as use a three-argument syntax. Here is an example:

=DAVERAGE(database,field,criteria)