Admit I'm surprised you say it works, as that's not exactly what you asked
for, viz:
.. If there are no numbers in E2-E20,
how can I make E21 to be blank
instead of showing a zero?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vi" wrote in message
...
Thanks - it works
"Mike H" wrote:
Try this in E21
=IF(SUM(E1:E20)0,SUM(E1:E20),"")