Thread: text as an argument of SUM function
View Single Post
  #3   Report Post  
 
Posts: n/a
Default text as an argument of SUM function
Have a look at the Indirect() function in help

eg.
=SUM(INDIRECT("'X1:X3'!A" & ROW()))

hth RES
Reply With QuoteReply With Quote