A character count in the spreadsheet

[tax112]

Hello everyone
I'm trying to count the letters "A" in my data tables ..
Results as attachments.
Thank you in advance

[Leith Ross]

Hello tax112,

Place this formula in cell N2 and drag it down to N6

=COUNTIF($A2:$J2, "*" & $N$1 & "*")

Place this Formula in N7

=SUM($N2:$N6)

[tax112]

Hello tax112,

Place this formula in cell N2 and drag it down to N6

=COUNTIF($A2:$J2, "*" & $N$1 & "*")

Place this Formula in N7

=SUM($N2:$N6)

Not really
results column N

[Leith Ross]

Hello tax112,

WTF "Not really" ?

[Leith Ross]

Hello tax112,

WTF "Not really" ?

[tax112]

Hello tax112,

WTF "Not really" ?

In my file
Row(2: 2): Character "A" in cell A2, D2, E2, G2, only 1
Row(3:3): Character "A" in cell B3, F3, only one .......

Finally the total character "A" appears as 3

[tax112]

I'm trying to solve this problem with .... For next loop

Please Login or Register  to view this content.

Can someone help me solve the problem