Forum Discussion
Trying to use varible for row
i want to enter amount in cell E1. want to enter row number in E2. E2 can be a row number from 23 to 52 Then add E1 to cell E(E2) and keep running total in E(E2). Thanks for help on best way to do this.
10 Replies
DaneWeatherby The first part where you say "add E1 to cell E(E2)" is pretty clear and can be achieved with the INDEX function or the INDIRECT function. For example:
=E1+INDEX(E:E, E2)-OR-
=E1+INDIRECT("E"&E2)However, I'm unable to determine what you meant by "and keep running total in E(E2)" in the second part of the request. Perhaps if you shared some sample data or a screenshot with the expected results, someone might be able to assist you further.
- amount saved to advertising. enter row 24 amount saved to other expenses.
wonder why it doesn't work for me.
- good
