LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pass named range to user defined function returns #value! Ron Rosenfeld Excel Programming 0 November 10th 07 01:03 PM
Pass named range to user defined function returns #value! JMB Excel Programming 1 November 10th 07 12:24 PM
HLOOKUP using a named range returns #VALUE! MicheleO Excel Worksheet Functions 2 August 24th 06 06:06 PM
Trapping error from Empty Dynamic Named Range Casey[_105_] Excel Programming 5 June 13th 06 03:43 PM
Named range returns 1004 error Stu D. Excel Programming 0 September 3rd 04 09:37 AM


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"