Hi there
I have a challenge when using autofilter.
In the attached file I have sales reps with sales numbers.
I found out from Ozgrid to use subtotal formule in C2 to sum only lines visible. Ozgrid, thx a lot for that input.
However, in cell C3 I want to count number of records, but when filtering sales rep "A", then formula "counta" still counts all records, i.e. 27.
Question: What formula should I use to count only visible records, e.g. 7 records for sales rep "A"?
Ths in advance for any help.
Have a good day.
BR Stoffer, Denmark.