Forum Discussion
Counting the number of times a value occurs in Pivot Table
Hello all! This is my first question. I am attempting to count the number of weeks an agent wrote $500 or more in a week. I have a pivot table that gives each agent and the sum of all premium writ...
Hi Booker2401
you can use a COUNTIF-function.
Let's assume the first week of your Pivot is in column B and the last in column G and it starts in row 2.
This would be your formula:
=COUNTIF(B2:G2;">=500")
It might be, that you need to use , instead of ; depending on your regional settings:
=COUNTIF(B2:G2,">=500")