State difference between COUNTO and COUNTAO Function?
Answers
Answered by
1
Answer:
The COUNT function is generally used to count a range of cells containing numbers or dates excluding blanks. ... Where COUNT calculates the number of cells with a numerical value, COUNTA simply counts the number of cells that contain any value (that is, cells that are not blank).
Explanation:
please mark me brainliests .Do follow for more answers.
Answered by
0
Answer:
Olease mark me as brainliest.
Explanation:
The difference between them is that COUNT only counts cells containing numbers but COUNTA counts all cells that aren't empty. Think of it as “Count Anything”. Speaking of empty cells, there is also a COUNTBLANK() function that will count only empty cells
Similar questions