Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table header column included in calculation
I have been using a simple pivot table for several months. I am requesting a
count of cells containing data in that column. This month, for some reason, the count shows one digit higher than the actual count. When I did a Find on the column, it said that the character I was looking for was in the header column. I specified exact case and cell contents in the find dialogue box. For example, for December I wanted to count the number of cells in a column that contained the letter "E". The header label is Dec. How can I have the pivot table not count the column label? I have never had this problem before. Thanks for your assistance. -- Lori99 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculation in pivot table with value of a column | Excel Worksheet Functions | |||
Pivot Table: new column with a calculation | Excel Worksheet Functions | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
Stripping time in Pivot Table Column Header | Excel Worksheet Functions | |||
Header included in sort | Excel Worksheet Functions |