Adding up rows of text
 

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


--
chessboard82
------------------------------------------------------------------------
chessboard82's Profile: http://www.excelforum.com/member.php...o&userid=37280
View this thread: http://www.excelforum.com/showthread...hreadid=569882

Adding up rows of text
 

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,

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=569882

Adding up rows of text
 

maybe these will help

=countif(A1:A100,"apple")

or

=countif(A1:A100,A1)

"chessboard82" wrote:


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


--
chessboard82
------------------------------------------------------------------------
chessboard82's Profile: http://www.excelforum.com/member.php...o&userid=37280
View this thread: http://www.excelforum.com/showthread...hreadid=569882

Adding up rows of text
 

yes Thank you!!


--
chessboard82
------------------------------------------------------------------------
chessboard82's Profile: http://www.excelforum.com/member.php...o&userid=37280
View this thread: http://www.excelforum.com/showthread...hreadid=569882