| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting blank cell in pivot table
hi , i have a list of data where there are blank cell. i need to do a count
for the pivot table but the pivot is unable to count hw many blank data i have. what can i do to get teh pivot to coutn my blank data. i do not want to replace blank with any value. this is what the current pivot table is showing. Balance Jan Data Total 3 Count of Balance Jan 1 5 Count of Balance Jan 2 6 Count of Balance Jan 3 11 Count of Balance Jan 2 17 Count of Balance Jan 1 18 Count of Balance Jan 1 (blank) Count of Balance Jan Total Count of Balance Jan 10 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting blank cell in pivot table
=COUNTIF(A5:B9,"(blank)")
"violet" wrote: hi , i have a list of data where there are blank cell. i need to do a count for the pivot table but the pivot is unable to count hw many blank data i have. what can i do to get teh pivot to coutn my blank data. i do not want to replace blank with any value. this is what the current pivot table is showing. Balance Jan Data Total 3 Count of Balance Jan 1 5 Count of Balance Jan 2 6 Count of Balance Jan 3 11 Count of Balance Jan 2 17 Count of Balance Jan 1 18 Count of Balance Jan 1 (blank) Count of Balance Jan Total Count of Balance Jan 10 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting blank cell in pivot table
If you change the data field to Count Of Date rather than Count Of Balance
you will get the answer you are looking for. Hope that helps. "violet" wrote: hi , i have a list of data where there are blank cell. i need to do a count for the pivot table but the pivot is unable to count hw many blank data i have. what can i do to get teh pivot to coutn my blank data. i do not want to replace blank with any value. this is what the current pivot table is showing. Balance Jan Data Total 3 Count of Balance Jan 1 5 Count of Balance Jan 2 6 Count of Balance Jan 3 11 Count of Balance Jan 2 17 Count of Balance Jan 1 18 Count of Balance Jan 1 (blank) Count of Balance Jan Total Count of Balance Jan 10 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
counting blank cell in pivot table
hw can Balance Jan is my data label, the col of data tt i am counting.
"William Horton" wrote: If you change the data field to Count Of Date rather than Count Of Balance you will get the answer you are looking for. Hope that helps. "violet" wrote: hi , i have a list of data where there are blank cell. i need to do a count for the pivot table but the pivot is unable to count hw many blank data i have. what can i do to get teh pivot to coutn my blank data. i do not want to replace blank with any value. this is what the current pivot table is showing. Balance Jan Data Total 3 Count of Balance Jan 1 5 Count of Balance Jan 2 6 Count of Balance Jan 3 11 Count of Balance Jan 2 17 Count of Balance Jan 1 18 Count of Balance Jan 1 (blank) Count of Balance Jan Total Count of Balance Jan 10 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting blank cells in a pivot table | Excel Discussion (Misc queries) | |||
| How to clear the word '(blank)' from a cell in a Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot table and counting. | Excel Discussion (Misc queries) | |||
| Pivot Table Row Cell (Blank) | Excel Worksheet Functions | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Linear Mode
