Count With Filter

  • Hi there

    I have a challenge when using autofilter.
    In the attached file I have sales reps with sales numbers.

    In cell B2 and B3 I have succeded with formulas which will calculate when using filter in the list.

    However, in cell B4 I want to count number of records which are above value 500, but when filtering sales rep "A", then formula "Countif" still counts all records above value, i.e. 15.

    Question: What formula should I use to count only visible records above value 500, e.g. 4 records for sales rep "A"?

    Ths in advance for any help.
    Have a good day.

    BR Stoffer, Denmark

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!