How to Count Non-Empty Cells in a Pivot Table
keshia21
Posted messages
203
Registration date
Status
Member
Last intervention
-
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58207 Registration date Status Contributor Last intervention -
Hello,
I have a pivot table with 2 columns:
Column A with numbers
Column B with words.
For each column, I would like to count the number of non-empty cells.
But when I use COUNTA on column B of my pivot table, it returns the total number of cells.
The same happens when I use COUNT to count the non-empty cells in column A.
Is it really possible to use these formulas on a pivot table?
Do you have a solution for me, please?
Thank you
Have a good evening
Keshia
Configuration: Windows / Edge 100.0.1185.29
I have a pivot table with 2 columns:
Column A with numbers
Column B with words.
For each column, I would like to count the number of non-empty cells.
But when I use COUNTA on column B of my pivot table, it returns the total number of cells.
The same happens when I use COUNT to count the non-empty cells in column A.
Is it really possible to use these formulas on a pivot table?
Do you have a solution for me, please?
Thank you
Have a good evening
Keshia
Configuration: Windows / Edge 100.0.1185.29
