CountIF Visible Cells only

Hi

I've tried searching (and google'd) for a solution to my problem but i'm stuck, please bear with me here as it's been a very steep learning curve for me over the last few weeks trying to grasp VBA in excel:

I've setup a worksheet whereby rows can be Autofiltered between a start and finish date via a Userform which (after much mucking about with UK/US dates) seems to be working nicely now.

With the results of the Autofilter, i wish to count certain entries (in this case entries that are in column F) in the remaining visible rows.

The Workbook is about 'Cases' worked, and column F relates to how the 'Case' is cleared (Call, Letter, Referral). Effectively I want to be able to count 'Call', 'Letter' and 'Referral' entries once the Autofilter has been applied.

Any help on this would be hugely appreciated.

Thanks

Try something like:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($F$1:$F$100,ROW($F$1:$F$100)-MIN(ROW($F$1:$F$100)),,1)),--($F$1:$F$100="CALL"))

adjusting ranges and condition(s) to suit.