Good evening JustinD
Use Insert Function Average, Select Range and Click Insert Function, Average
that should do it

"JustinD" wrote:

Hi,

i know there is countless threads about this error but i really need a
straight up answer,

im just doing a standard average on serveral rows and then i recieve
the #DIV/0! error.

now to my knowledge the rows are set as numeric etc. all we need is a
simple average!

if anyone could help it would be greatfully appreciated :D

Thanks a tonne,

JD