sum number of cells based on letter/title criteria
 

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

sum number of cells based on letter/title criteria
 

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

"chazmac" wrote:


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

sum number of cells based on letter/title criteria
 

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