Hi,
scattered all around in my big excel sheet i have named some cells by name. And now i need a easy way to sum up the values in thos cells.
One of the cell name box values i have used "L11x361", "L11x362" and so on (just changing the last number).
I also need the sum to to calculate from "L11x361" to let's say "L11x3615" even tho i only have used up to "L11x369". This is just if i in the future add some new cells to this series.
If i just try to type "=L11x361+L11x362+L11x363+L11x364+L11x365+L11x366" (and so on up to value 15) It only shows "#NAME?" cause some of the name's hasn't been used!
Can anyone help me? Can this be done?
Bookmarks