COUNTIF visible cells matching specific criteria

Hello,

Can someone please help me!!!!

I had created a formula for COUNTIF, however once I applied a filter in my data this did not change my results and graphs. Reading some other posts I have been able to use the SUMPRODUCT formula, which works fine for just looking for the letter A on its own. However I can't get it to work when the letter A is within a word.

This is the formula I am currently using:

=SUMPRODUCT(SUBTOTAL(3,OFFSET('Error Sheet'!I2:I60000,ROW('Error Sheet'!I2:I60000)
-MIN(ROW('Error Sheet'!I2:I60000)),,1)), --('Error Sheet'!I2:I60000="A"))

I Have tried *A* but this also doesn't work.

Any Help would be greatly appreciated as this is the only problem I am having to complete my project.

Many Thanks

MP

I don't know why, but I always prefer to put the subtotal in a column by itself, then add a criteria to a countifs formula for 1 on that column..

Say your original countif is
=COUNTIF('Error Sheet'!I2:I60000,"*A*")

Then in an available column, Say M on the Error Sheet..
M2: =SUBTOTAL(103,I2)
And Fill down.

Then you can use column M in countifs, testing it for 1.
=COUNTIF('Error Sheet'!I2:I60000,"*A*",'Error Sheet'!M2:M60000,1)

Thank you daddylonglegs!!!!!!

It works brilliant and thank you for the quick reply!!!!