sum number of cells based on letter/title criteria

[chazmac]

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

Cha

 

[Guest]

Easiest is probably to create a Pivot Table. Select your data range then
Data > Pivot Table. When you get to Layout, drop 'titles' into the row field
AND into the data field. Check what shows in the column field; you want it
to be Count of Titles. If not, double-click on it and you can change the
'summarize by.'
If you don't want a Pivot Table, you can also use countif:
=countif(a:a,"Senior VP"), etc.
--Bruce

 

[Bob Phillips]

If the other cells are blank, you could use

=COUNTA(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)