View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Popik Popik is offline
external usenet poster
 
Posts: 2
Default Another Advanced Cell Reference

Hello,

A follow-up to my previous question. I would like to sum from cell A1
through cells in row 1, column A + indirect(example number). I am unable to
use the string =sum(A1:address(example code)) because the sum function will
not allow address() as an argument. Suggestions?

Thank you for your help.