Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Include sheetname dynamically in named range? | Excel Discussion (Misc queries) | |||
Dynamically Changing Named Ranges | Excel Worksheet Functions | |||
Add a data series dynamically to a named range? | Charts and Charting in Excel | |||
dynamically building references to named ranges | Excel Discussion (Misc queries) | |||
How to dynamically reference a dynamic named range | Excel Worksheet Functions |