I need a simple AVERAGE formula

[PhotogTalia]

Hello,

Iīm in need of a simple average formula for the following numbers. Please note that the Blank spaces (cells) should NOT be included in the formula.

75%
80%
75%
80%
95%
100%
100%
90%
80%
75%
50%
85%

55%
75%
90%
75%
100%
100%
90%
75%
80%
95%
90%
75%

90%
80%

100%
75%
85%
75%
95%
75%
85%
90%

I know how to create the average formula but I donīt know how to create the string of cells while excluding the blank cells.

Thank you!

[Pete_UK]

AVERAGE ignores blank cells, so you can just do:

=AVERAGE(range)

Hope this helps.

Pete

[PhotogTalia]

Simple enough! Thank you!