Thread: How can I make a blank cell in a formula cell with a range of cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How can I make a blank cell in a formula cell with a range of cell
Try this in E21

=IF(SUM(E1:E20)0,SUM(E1:E20),"")

Mike

"Vi" wrote:

Example: I have a column of numbers I want to add E2:E20 with the total in
E21. If there are no numbers in E2-E20, how can I make E21 to be blank
instead of showing a zero?
Thanks
Reply With QuoteReply With Quote