Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting blank cells in a pivot table
I created a pivot table to keep count of inquiries and orders received. I
also want to a count of how many inquiries are quoted a day. I also want a count of how many are left unquoted. To do that it would have to count the blank fields under the inq. quoted column. I can only get it to count the cells that have data in them but not the blank cells....how do I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting blank cells in a pivot table
The pivot table can't count blank cells, so if you put a field (e.g.
Inquiries) in the row area, and Count of Inquiries in the data area, the (blank) item will show nothing in the data area. However, if you add a different field to the data area, you may see the correct count. For example, if the Date field always has a value, add that to the data area, and summarize by Count. The pivot table will then show the count of records with a blank Inquiries field. mercedes wrote: I created a pivot table to keep count of inquiries and orders received. I also want to a count of how many inquiries are quoted a day. I also want a count of how many are left unquoted. To do that it would have to count the blank fields under the inq. quoted column. I can only get it to count the cells that have data in them but not the blank cells....how do I do that? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
removing the word (blank) from pivot table cells | Excel Discussion (Misc queries) | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
formulas referencing pivot table cells | Excel Worksheet Functions |