Thread: SUM() of empty dynamic named range returns #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Aviashn Aviashn is offline
external usenet poster
  
Posts: 17
Default SUM() of empty dynamic named range returns #N/A
I have a cell with =SUM(CamperRev) where CamperRev is a dynamically
named range containing contribution amounts. This works fine if there
are any contributions, but displays #N/A if there are not.

I worked around this with
=IF(ISNUMBER(SUM(CamperRev)),SUM(CamperRev),"") but was wondering if
there is a better way.
Reply With QuoteReply With Quote