| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
