Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel pivot table count blank cells?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel pivot table count blank cells?
The pivot table can't count blank cells, so if you put a Product field
in the row area, and Count of Product 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 Invoice 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 product field. scrufty wrote: -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make excel pivot table count blank cells?
Thank you for your prompt response. It is disappointing. The information is
right there. I added a zero in source file and ran the pivot table again. It worked. "Debra Dalgleish" wrote: The pivot table can't count blank cells, so if you put a Product field in the row area, and Count of Product 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 Invoice 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 product field. scrufty wrote: -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table - Repeating Lables | Excel Worksheet Functions | |||
create pivot table from excel table | Excel Worksheet Functions | |||
count of (blank) pivot table | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions |