Thread: Error or Not?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Error or Not?

=IF(COUNT(V8:V50)=0,"",SUM(V8:V50)/43)

A variation of the above,
which avoids having to "manually" count the "43":
=IF(COUNT(V8:V50)=0,"",SUM(V8:V50)/ROWS(V8:V50))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---