| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to rows? | Excel Discussion (Misc queries) | |||
| Adding rows in several worksheets along with formulas | Excel Discussion (Misc queries) | |||
| Selective deletion of rows containing certain text. | Excel Worksheet Functions | |||
| opening text files that have more rows than 65536 | Excel Worksheet Functions | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Hybrid Mode
