Forum Discussion

PLipps's avatar
PLipps
Copper Contributor
Apr 22, 2023

using database functions

When using Database functions in excel to calculate a total number of people from a certain column, what is the best Database function to use?

Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 22, 2023

    PLipps 

    I asked the Bing chatbot and got this answer:

    One of the best database functions to use when calculating the total number of people from a certain column in Excel is the DCOUNT function. This function counts the number of cells that contain numbers within a list or database that match a given set of conditions. You can use this function by specifying the database range, field, and criteria range as arguments in the formula. For example: =DCOUNT(database, field, criteria).

     

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Apr 22, 2023
    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.

Resources