How to count # of values which exceed 1000?

[#1]

I have a pivot chart which has the following:

                      1             2             3    …

Shehan     975       1050     1102

James       950       1175     1101

Stewart    1105       980       985

Emmett   1000     1005       975

I need a fourth column where it looks and counts the number of values which exceed 1000.

                      1             2             3    …    overages

Shehan       975       1050     1102              1

James         950       1175     1101              2

Stewart      1105       980       985              1

Emmett     1000     1005       975              0

[its_anandrjs · Accepted solution]

Hi,

See the attached sample file i think you use like this see the fourth expression overages in the pivot table on the Solution sheet

See the attached sample.

Regards,

Anand