Countif

  • Thread starter Thread starter Julian Sudbury
  • Start date Start date
J

Julian Sudbury

From Sheet2 I am trying to count the number of occurences
of a particular Text field in Sheet1
i.e. =COUNTIF(Sheet1!D1:BK5000,"Bulk Mailing")

This works fine, however I need to then apply a filter to
Sheet1 and then only count the number of text occurences
left after the filter is applied.

The Countif is still counting the whole work sheet

Does anybody know how to get round this issue?

Thanks
Julian
 
Hi
try:
=SUMPRODUCT((SUBTOTAL(3,OFFSET(INDEX(sheet1!$A$1:$A$5000,1,1),ROW(sheet
1!$A$1:$A$10)-ROW(INDEX(sheet1!$A$1:$A$5000,1,1)),0))=1)*(sheet1!$D$1:$
BK$5000="Bulk Mailing"))
 
Back
Top