In excel, how to count the number of "A" in n cells (horizontal) starting from a certain cell

yujinxu

When I use excel, I want to count the number of 'A' in n horizontal cells starting from A1, but there seems to be no suitable function. Although the COUNT function can be calculated, I need to write a clear range, such as from A1 : H1, I want to know, if I don't know the certain range, what should I do based on the value entered by the user?

wzqiiiiii

Use countif to see
= COUNTIF (A1: H1, "A")

But this method can only be applied to statistics where one cell contains only one A.

caiyiangel

I want to know, if I don't know the certain range, what should I do based on the value entered by the user?
-------------------------------------------------- ----
Without VBA, you can specify operations for specific rows.
Change the method provided bywzqiiiiiito
= COUNTIF (1: 1, "A")
Just fine.

By the way, in Excel 2003, each sheet can only have a maximum of 256 columns (the column name is IV) or 65536 rows, so it can be written like this
= COUNTIF (A1: IV1, "A")
I just tried it by the way, = COUNTIF (A1: IV1, "A") will be automatically converted to = COUNTIF (1: 1, "A")

z11111111

If I do n’t know the determined range, it should be determined based on the value entered by the user
=============================================
Suppose the user can enter the range of cells (the first row) the user needs in cell A2, and display the result in B2:

= COUNTIF (INDIRECT (A2), "A")

If you enter in cell A2: A1: A5
Then the result of the formula is the number of A in cell range A1: A5