Thread: #REF error!
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom tom is offline
external usenet poster
 
Posts: 570
Default #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