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)