SUM number of VISIBLE occurrences of a given term, filtered rows

Hi all, I've been unable to find a solution to this on this forum or Google...

I have a table ('Member Data'!$AF$10:$AF$75945) where I want to add up the number of occurrences of the term "Community Talk" in a particular column (G), but only for visible rows (the table gets filtered).

I thought I was on the right track with a helper column (AF) that was =IF(G10="Community Talk","1","") and then SUBTOTAL that (=SUBTOTAL(109, 'Member Data'!$AF$10:$AF$75945), but nothing comes up. The SUBTOTAL function works if I manually enter 1's into the column AF, but it doesn't recognize the results of the IF function as a number to SUM. I'm not sure if the formatting affects this, but I tried changing it to Number with no luck.

Thank you in advance for any suggestions!

Randy

Formatting does NOT affect it, but you're on the right track that it's not treating it as a number, because you're not returning the number 1 with your IF, you are returning the text string "1". Yes, those are different and yes it matters, LOL.

this would work instead:

Please Login or Register  to view this content.

Then use this for the summation:

Please Login or Register  to view this content.

AGGREGATE with function 9 (sum) and option 5 (ignore hidden rows) will do what you want.