Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the field that contains blanks is in the Row area, add another field,
that contains data in every record, to the Data area. For that field, change the Summary function to Count, and it will show a count of the blank items. ben****er2 wrote: I cannot figure out why in my pivot table, it sums all the appropriate data, but does not return a count of "blanks". This is a critical piece of managing the data. Any suggestions. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum vs. Count in Pivot Tables | Excel Discussion (Misc queries) | |||
Add quartiles and mode functions to pivots tables in Excel! | Excel Discussion (Misc queries) | |||
How do I stop my Pivot tables from spelling out (blank)? | Excel Discussion (Misc queries) | |||
HOW TO MERGE TWO TABLES | Excel Worksheet Functions | |||
Hiding rows containing zeroes or blanks in pivot tables? | Excel Discussion (Misc queries) |