If the other cells are blank, you could use

=COUNTA(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"chazmac" wrote in
message ...

Hello,
I'm wondering the best way to sum the number of cells that have titles
or written content in them. This is so I can tell my printer exactly
how many tabs I have for binders I'm producing without counting each
filled cell in the column. Tab titles are always in the same column,
always have different titles, and the cells are not sequential; other
rows break up the titles. Hopefully this query isnt too convoluted,
and any help is much appreciated.

Chaz


--
chazmac
------------------------------------------------------------------------
chazmac's Profile:
http://www.excelforum.com/member.php...o&userid=28972
View this thread: http://www.excelforum.com/showthread...hreadid=488779