I want to count the non blank cells in pivot table columns and have been using counta but this means I have to change the formula each time I change the filters. I have read that it is possible to use Counta in a Pivot table but despite a number of goes I have to accept defeat as its beyond me.
Any help gratefully accepted.
Which version of Excel do you have?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Maybe count directly from the table?
=COUNTIFS($C$2:$C$2261,N4,$D$2:$D$2261,G1)
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No further help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks