Excel query - countifs / averages etc

[techno]

Hello All

Thanks for the help in advance.

I am trying to figure out the code i need in excel.

All i want to do is get the average of a series of 15 numbers in cells.
The problem is it counts the blank cells as zero.

How do i stop the zero being included in the average figure completely?

Cheers

 

[vinnie107]

Just select the ones that you want and not the blanks. Press ctrl whilst you click on them.

 

[Cromewell]

Are you sure the nulls are being included? I just ran a range average and selected cells average with null values and it's giving me the same number back.