calculate what my running percentage is concerning the days when i have made

Hiy
Could you help me at all please?

I have a long column full of 'y's or 0s , either a Y in it for yes I made sales that day or a zero in it if i havent.

could excel perhaps calculate in a cell what my running percentage is concerning the days when i have made sales ie the number of Ys in the column compared to the total days?

Thanks if you can help in any way.

Hi and welcome to the board

Try

=average(if(a1:a100="y",a1=a100,false))

Adapt the range to your needs

And most important, enter this formula as an array formula with Ctrl+Shift+Enter

Cheers

Perhaps =AVERAGE(IF(A1:A100="y", 1, 0)) (also an array formula)

Or, (probably faster), =COUNTIF(A1:A100, "y") / ROWS(A1:A100) (regular formula)