Functions that can count.

Hey there! Can you tell me what the Counta function does?

• Counts non-empty cells in a range

• Returns the maximum value in a range

• Counts cells with text values

• Calculates the average of a range

Hey there! Can you tell me what the Count function does?

• Counts the number of cells that contains numbers.

• Counts the number of columns in a table

• Calculates the sum of all values in a specified column

• Returns the average value of a specified column

Hey there! Can you tell me what the Countblank function does?

• Highlights all blank cells within a specified range.

• Returns the sum of all blank cells within a specified range.

• Counts the number of filled cells within a specified range.

• Counts the number of blank cells within a specified range.

Which function do I use if the contents of my cells are alpha-numeric?

• Count

• Countblank

• Counta

• CONCATENATE

Which function to count do I use if my cell contains only numbers?

• Counta

• Sum

• Count

• Countblank

Which function do I use to count empty cells?

• Countblank

• Counta

• Sum

• Count