Thread
:
Error or Not?
View Single Post
#
6
Posted to microsoft.public.excel.newusers
Max
external usenet poster
Posts: 9,221
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
---
Reply With Quote
Max
View Public Profile
Find all posts by Max