Kiến thức

What is the difference between count and counta in Excel?

What is the difference between count and counta in Excel?

The COUNT function is generally used to count a range of cells containing numbers or dates excluding blanks.

COUNTA, on the other hand will count everything… numbers, dates, text or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for count all.

Although you can use COUNTA to generate the number of clients or employees in a list, it counts each entry, not unique entries. To count unique entries you would have to use the SUM function together with the COUNTIF function.

An example of using both functions is given below:

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).

Record # Part #
1 1,569 COUNT
2 1,589 8
3 1,629
4 1,758
5 2345-01 COUNTA
6 2345-02 10
7 1,878
8 1,985
9 1,998
10 2,010

Related forum posts:

Bạn đang xem: What is the difference between count and counta in Excel?

Counting items in columns.

Can you please advise the best way to count the number of items which are listed in a column. ( eg a list of names attending a conference?) thanks

Read forum post


Xem thêm: [Hướng dẫn] Cách tính diện tích tam giác thường-vuông-cân


What is CountA

Read forum post



How is the easiest way to Count the number of Items in a list which are words. For example if you had a list of Hotels in London and Edinburgh, how can you easily count the london entries, without putting in an extra column with 1 in it?

Read forum post


Xem thêm: Chương 6-Bài 34: Sơ lược về laze

Excel intro

What is the difference between count – countA?

Read forum post


Xem thêm: Dung môi Toluene (TOL)


How do you use Count A

Read forum post


Related articles

Learn The Secrets Of COUNT Functions In Excel

Once you’ve created calculations in Excel you might then have moved on to use Excel’s own built in calculations in the form of functions. A popular Excel function is COUNT and this article summarises the different COUNT functions available and describes how each are used.

Read article


Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Back to top button