Hi all,
Is there any formula that would sum only the 12 cells to the left of the formula, even if you then add in new cells the formula still only calculates the 12 cells to the left?
I hope that makes sense
Thanks in advance
Hi all,
Is there any formula that would sum only the 12 cells to the left of the formula, even if you then add in new cells the formula still only calculates the 12 cells to the left?
I hope that makes sense
Thanks in advance
Using a named range would be one way of solving it I think. Are you going to add cells or columns?
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
sum(a1:L1) and drag to the right.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks