Hello,
These are two ways I've found to do interactive sums: "=SUM(OFFSET(A1;0;0;F1;1))" or "=SUM(INDIRECT("A1:A"&F1) )", summing the cells on column A:A and many times as determined in the Cell F1.
I'am wondering if there's any way to sum Rows instead of Columns? I'm not getting it!
Thanks for your help.
cpmsimoes
=SUM(INDIRECT("A1:"&F1&"1") )
Where F1 is your letter(G, T,AS...)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Hi,
Two possibilites:
=SUM(OFFSET(A1,,,,F1))
or
=SUM(A1:INDEX($1:$1,,F1) )
Regards
Thank you both.
All the solutions work.
Regards
cpmsimoes
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks