COUNTIF for filtered data

Hi nataliemur and welcome to the forum,

I just answered this problem a few hours ago at: https://www.excelforum.com/excel-pro...her-sheet.html

If you want a better and quicker answer then give us an attached file like the above post did.

I hope you get a good answer soon.

Maybe you missed an piece of the formula?
=SUMPRODUCT(SUBTOTAL(102,OFFSET(V2,ROW(V2:V800)-ROW(V2:V800),,1))*(V2:V800=1))

Are you counting only numbers (102) or perhaps want to CountA with 103 for both text and numbers?

There is a #VALUE! error in cell V3 that needs attention first. That is one of the many reasons we ask for a sample file. We couldn't know that was there without the upload. Array enter this modification of your formula.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

You are welcome. Glad to help and thank you for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.