COUNT function

[mikehk]

I am using this formula for chart

=OFFSET(Stats!$O$2,,,COUNTA(Stats!$O:$O),1)

it counts cells those are empty but have formula

how to count cells with numbers or text, cells those are
empty but have formula in them need not be counted.

Thank you.

[FDibbins]

Cells with formulas are not empty. Try changing to COUNTIFS()
=OFFSET(Stats!$O$2,,,COUNTifs(Stats!$O:$O,"<>"),1)

It may, however, be better if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.