Sum
 

How can i sum the number of cells in a column that have text. B4 -B32 have
text in them. I wanted to have teh number cells summed up so in B33. so if B4
= John and B5 = Suzy...so B33 would say 2....any ideas??

Sum
 

Use the COUNTA function, For Example:

=counta(B4:B32)


"chip_pyp" wrote:

How can i sum the number of cells in a column that have text. B4 -B32 have
text in them. I wanted to have teh number cells summed up so in B33. so if B4
= John and B5 = Suzy...so B33 would say 2....any ideas??

Sum
 

hi!

try this one!!

in B33

=counta(b4:b32)-count(b4:b32)

-via135


Vick Wrote:
Use the COUNTA function, For Example:

=counta(B4:B32)


"chip_pyp" wrote:

How can i sum the number of cells in a column that have text. B4 -B32
have
text in them. I wanted to have teh number cells summed up so in B33.
so if B4
= John and B5 = Suzy...so B33 would say 2....any ideas??


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=512302