=IF(V8:V50="","",SUM(V8:V50/43))
One way is to try it as:
=IF(COUNT(V8:V50)=0,"",SUM(V8:V50)/43)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DavidB" wrote:
Thanks JMB and Max extremely helpful.
I have one more small problem and that is this formula:
=IF(V8:V50="","",SUM(V8:V50/43))
I understand the principle of AVERAGE but I get that #VALUE! in the
destination cell V51. Is this a format issue? can V51 be blanked so that it
shows nothing?
Cheers
David