Desperate need for and Average Formula

[Drinking_and_Formulas]

Using A1:A4 *Note: I am pulling data from another spreadsheet.

I am currently using =AVERAGE('Data Entry'!D4:'Data Entry'!D29). This works great right now because my numbers are 1,1,1,0. 75% is what I'm looking for.

But these numbers are subject to be changed. So what i'm looking for is a formula that would use 1,5,3,0 and come back with 75%. Basically, no matter what the number is, it gets counted as 1 unless its zero.

 

[Matty]

Welcome to the Board!

Try:

=COUNTIF(A1:D1,">"&0)/COUNT(A1:D1)

And format the Cell as %.

Matty

 

[VoG]

Try like this

=COUNTIF(A1:A4,">0")/COUNT(A1:A4)

 

[Drinking_and_Formulas]

VoG, Thanks so much! That worked perfect! A toast to you!

Matty, Thanks for the reply, never ended up trying it but I'm sure it would work too being the small variance in your formula's.