Difference between COUNT, COUNTA, COUNTIF and COUNTBLANK in Ms-Excel

Data Science, AI and ML
#1

  • COUNT is a function that counts cells that contain numbers, dates, or any other value that is stored as a number, except blanks.

  • COUNTA is an abbreviation for Count. All are used to count any cell value that contains numbers, text, logical values, etc., but not blanks.

  • COUNTBLANK counts cells that are blank or have an empty string.

  • COUNTIF and COUNTIFS are functions that count cells that meet a set of conditions.