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.