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