View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default question about cell reference in a formula

Hello,

I have this formula for a cell:
SUM(INDIRECT("C"&A18):INDIRECT("C"&B18))

How can I dynamially reference the column in which the cell is in,
rather than using "C", as shown above?

Thank you.

Kelie