Pivot Table or simple filter and count?

Mark O'Mahoney
Occasional Contributor



I am struggling to count a 'word' using Pivot table. I need to see the number of 'very important' across 5 different columns. I thought I could do this via pivot table but it doesn't seem to be showing me values. I am looking for a quick solution via Pivot rather than a filter and manually count as I will need to do this for a bigger excel document afterwards. 


I am sure there is a very easy solution - if anyone could help I would be very grateful!





3 Replies

How about a formula like the attached ?



Hi Wyn, this formula is perfect. I'm not sure if this is possible via a pivot so a simple formula works. Many thanks!
Great, no it's not possible with a pivot
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies