LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default Dynamically Named Range and IsError()

Greetings! Thanks for any help! Before starting, I don't necessarily need a
treatment, I'm really hoping for a diagnosis.

I have a range defined as the following:

=OFFSET(Entries!$E$2,0,0,COUNTA(Entries!$E:$E)-1,1)

It expands each time a payment is entered and column E is the amount field.
Everything is fine to this point.

On a summary page there is a cell totalling the payments, which my
application checks. The formula is:

=IF(ISERROR(rAmount),0,SUM(rAmount))

Everything is still fine... Unless the user enters exactly 2 or 3 payments
throughout the day. One payment works, four payments and up works, but two
or three payments causes the named range to return an error.

Does anyone have any idea what might cause this? For the record, no error
is returned if the formula is changed to

=IF(ISERROR(SUM(rAmount)),0,SUM(rAmount))

Any help is appreciated. Thanks in advance!
 
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
Include sheetname dynamically in named range? Dallman Ross Excel Discussion (Misc queries) 2 March 18th 08 01:49 PM
Dynamically Changing Named Ranges [email protected] Excel Worksheet Functions 2 December 17th 07 08:04 PM
Add a data series dynamically to a named range? Popeye Charts and Charting in Excel 3 March 10th 06 08:59 PM
dynamically building references to named ranges [email protected] Excel Discussion (Misc queries) 1 January 3rd 06 10:23 PM
How to dynamically reference a dynamic named range paris3 Excel Worksheet Functions 4 June 24th 05 01:22 AM


All times are GMT +1. The time now is 11:36 PM.

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"