Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
Is there a way i can count the number of cells in a particular column that
have text? Right now, for example, I have B4 - B32 that have a name in them, what i was trying to do is sum that up on B33 so the value in B33 would be x number of cells that have text...if that makes any sense |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
The COUNTA function will give you the number of cells that are
either numbers or character text. =COUNTA(A1:A10) If you want to count only those cells with character text, and not count numbers, use =COUNTA(A1:A10)-COUNT(A1:A10) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "chip_pyp" wrote in message ... Is there a way i can count the number of cells in a particular column that have text? Right now, for example, I have B4 - B32 that have a name in them, what i was trying to do is sum that up on B33 so the value in B33 would be x number of cells that have text...if that makes any sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|