| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#REF error!
THANKS, Lars, how did you know that?
How can I get up to your level of expertise? Tom "Lars-Ã…ke Aspelin" wrote: On Sat, 19 Sep 2009 09:38:01 -0700, Tom wrote: =IF(D$1+1<=ROW(),SUM(INDIRECT("RawData!F" & ROW()-D$1+1&":RawData!F" & ROW())),"") Try to remove the second "RawData!", like this: =IF(D$1+1<=ROW(),SUM(INDIRECT("RawData!F" & ROW()-D$1+1&":F" & ROW())),"") Hope this helps / Lars-Ã…ke |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Threaded Mode
