counting text based cells
 

Hi, can you help me with formula for this:


XY A B C A B B A C 3

XX B C A B C A C B 2


I need to count "A" and sumarize it at end of row i.e. 3


Thank you

counting text based cells
 

XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3

Looks like a job for COUNTIF, maybe something like
=COUNTIF(A1:K1,"A")

Modify as needed.

counting text based cells
 

On Sunday, 1 March 2015 18:47:05 UTC+1, zvkmpw wrote:
XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3

Looks like a job for COUNTIF, maybe something like
=COUNTIF(A1:K1,"A")

Modify as needed.


Works, thank you very much.

Rgds