Hi All,

So today i found out that i can't use 
=Countif(F:F,F2)
to show me how many times an acc# showes up if the excel sheet is auto filtered. I then tried 
=SUMPRODUCT(SUBTOTAL(3,OFFSET(F2,ROW(F2:F10100)-ROW(F2),0)),(F2:F10100="F2")+0)
But it seams i can not refference a cell. any help?