| 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? |
| 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 | |||
Threaded Mode
