Thread
:
counting text based cells
View Single Post
#
2
Posted to microsoft.public.excel.misc
zvkmpw
external usenet poster
Posts: 153
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.
Reply With Quote
zvkmpw
View Public Profile
Find all posts by zvkmpw