Adding up rows of text

C

chessboard82

I have a number of cells in a colomn with the same text in them and
wondered if there is a way of counting up the number of time that same
text appears. Like a sum with text if that makes sense! Thanks
 
R

Ron Coderre

Try something like this...

To count the number of cells in A1:A100 that contain "MyText":
=COUNTIF(A1:A100,"MyText")

Note: COUNTIF is not case-sensitive.


Does that help?

Regards,

Ro
 
Top