using database functions

There are several database functions that can be used in Excel to calculate a total number of people from a certain column, as simply example the COUNTA, COUNTIF and COUNTIFS. One of the simplest examples is the COUNTA function. COUNTA simply looks at a range of cells and tells you how many of the cells contain data. In other words, it looks for nonblank cells. Another useful function is COUNTIF, which counts values when a single condition is met. COUNTIFS can test a single or multiple conditions and is far superior³. Several other database functions can be used in Excel to calculate a total number of people from a certain column. Some other useful functions include SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS. These functions allow you to perform calculations based on certain conditions.