Hello,

Sorry if there is already a post for my question but I didn't find any.

I already search for several days how to sum cell content but using relative position. In the worksheet I have several contracts, each contracts have several amounts, not always the same number of amount : I would like to sum those amounts per contract.
I have already in different cells :
- the number of amount
- the begin location of the amount for the contract : "=ADDRESS(N33;10)"
- the last location of amount for the contract : "=ADDRESS(O33;10)"
but I can't do : "=sum(ADDRESS(N33;10):ADDRESS(O33;10)" or something like that without having an error.
The worksheet contains around 30000 lines.
I don't want to do it in VBA (because I'm not used to :-( )

Thank you for your help (and your patience).
Renée