View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Khoshravan Khoshravan is offline
external usenet poster
 
Posts: 211
Default Using range with INDIRECT and ROW()

Could you please explain what do you want to do?

"Paranormal Gravy" wrote:

I am setting up a spreadsheet that with add columns in a row, but need
it to be applicable to various rows, I hacked this formula together so
far:
=SUM(INDIRECT("A"&ROW()), INDIRECT("B"&ROW()), INDIRECT("C"&ROW()),
INDIRECT("D"&ROW()), INDIRECT("E"&ROW()))
Anyone have a suggestion how to improve this formula?