software

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??

Use the COUNTA function, For Example:

=counta(B4:B32)quot;chip_pypquot; wrote:

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


hi!

try this one!!

in B33

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

-via135Vick Wrote:
gt; Use the COUNTA function, For Example:
gt;
gt; =counta(B4:B32)
gt;
gt;
gt; quot;chip_pypquot; wrote:
gt;
gt; gt; How can i sum the number of cells in a column that have text. B4 -B32
gt; have
gt; gt; text in them. I wanted to have teh number cells summed up so in B33.
gt; so if B4
gt; gt; = John and B5 = Suzy...so B33 would say 2....any ideas??--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=512302