Using a variable number of cells in SUM function
Hello everyone.
Here's my problem: I need to sum some adjacent cells in a column, but the number of cells varies (according to a value in another cell). In the SUM function you need to specify all the cells. Is there a way to solve this?
If it can't be done, I guess I'll need to do it via VBA right?
Thanks!
Formula:
Please Login or Register to view this content.
B2 contains the start cell/column; C2 contains the number of cells/columns.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello TMS!
I'm getting a "The formula you typed contains an error.".
Can you help me understand your formula? I can see that it's possible to reference to a cell, but I'm not getting the whole thing.
I'm updating an excel file so you can better undersand my problem, can you apply that formula on that sheet?
Thank you very much for the attention!
Help.xlsx
This is simple but might suit:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 03-14-2014 at 04:11 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Cell D2:and copy down.Formula:Please Login or Register to view this content.
Or
Cell D2:Formula:Please Login or Register to view this content.
Variations on a theme depending on your data structure.
See the updated example attached
newdoverman, that works! Just had to make some adjustments.
And TMS, your solution worked too!
Thank you both for the attention!
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
Thank you for the feedback. I am curious as to the amendments you made to make the proposed solution fit your problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks