Counta

 The COUNTA function in Excel is used to count the number of cells in a range that are not empty. It counts cells containing numbers, text, logical values, errors, and empty text (""), but it does not count truly empty cells.

Here are 10 examples of how to use the COUNTA function, including data and formulas:

---

Example 1: Basic Usage

Count the number of non-empty cells in a single column.

Data:

Copy

A
1 Apple
2 Banana
3 
4 Orange
5 

Formula:

excel

Copy

=COUNTA(A1:A5)

Result: 3 (Counts "Apple", "Banana", and "Orange").

---

Example 2: Count Non-Empty Cells in a Row

Count non-empty cells in a row.

Data:

Copy

A   B   C   D
1 X     Y     Z

Formula:

excel

Copy

=COUNTA(A1:D1)

Result: 3 (Counts "X", "Y", and "Z").

---

Example 3: Count Non-Empty Cells in a Range

Count non-empty cells in a 2D range.

Data:

Copy

A   B   C
1 1     2
2     3 
3 4     5

Formula:

excel

Copy

=COUNTA(A1:C3)

Result: 5 (Counts 1, 2, 3, 4, and 5).

---

Example 4: Count Non-Empty Cells with Mixed Data Types

Count cells with numbers, text, and logical values.

Data:

Copy

A
1 Apple
2 10
3 TRUE
4 
5 #DIV/0!

Formula:

excel

Copy

=COUNTA(A1:A5)

Result: 4 (Counts "Apple", 10, TRUE, and the error #DIV/0!).

---

Example 5: Exclude Empty Text ("")

Count non-empty cells, excluding cells with empty text ("").

Data:

Copy

A
1 Apple
2 
3 ""
4 Orange

Formula:

excel

Copy

=COUNTA(A1:A4)

Result: 3 (Counts "Apple", "", and "Orange").

---

Example 6: Combine COUNTA with IF

Count non-empty cells that meet a condition.

Data:

Copy

A
1 Apple
2 Banana
3 
4 Orange

Formula:

excel

Copy

=COUNTA(IF(A1:A4<>"", A1:A4))

Result: 3 (Counts "Apple", "Banana", and "Orange").

---

Example 7: Count Non-Empty Cells Across Multiple Columns

Count non-empty cells in multiple columns.

Data:

Copy

A   B   C
1 X     Y
2      Z
3 W     

Formula:

excel

Copy

=COUNTA(A1:C3)

Result: 4 (Counts "X", "Y", "Z", and "W").

---

Example 8: Count Non-Empty Cells in a Filtered Range

Count visible (non-filtered) non-empty cells.

Data:

Copy

A
1 Apple
2 Banana
3 
4 Orange

Steps:

1. Apply a filter to exclude "Banana".

2. Use the formula:

excel

Copy

=SUBTOTAL(103, A1:A4)

Result: 2 (Counts "Apple" and "Orange" after filtering).

---

Example 9: Count Non-Empty Cells with Formulas

Count cells with formulas that return non-empty values.

Data:

Copy

A
1 =IF(1=1, "Apple", "")
2 =IF(1=2, "Banana", "")
3 
4 =IF(1=1, "Orange", "")

Formula:

excel

Copy

=COUNTA(A1:A4)

Result: 2 (Counts "Apple" and "Orange").

---

Example 10: Dynamic Range with COUNTA

Count non-empty cells in a dynamic range.

Data:

Copy

A
1 Apple
2 Banana
3 
4 Orange

Formula:

excel

Copy

=COUNTA(A:A)

Result: 3 (Counts all non-empty cells in column A).

---

These examples demonstrate the versatility of the COUNTA function in Excel.