Hi Dave,

Thanks for replying.

Duke's last post sorted the problem when I remembered (again) to add as an
array!

Thanks
--
Mifty


"Dave Peterson" wrote:

If you're just trying to stop the division by 0 error:

=if(count(p1:p4)=0,"",average(p1:p4))



Mifty wrote:

Hi everyone,

Could anyone help and tell me what's the matter with this please?

=if(p1:p4<,"",AVERAGE(IF(P1:P40,P1:P4,FALSE))

Scratching my head - feels like a Friday not a Thursday :-)

--
Mifty

--

Dave Peterson