LinkBack URL
About LinkBacks
lucasar 
Formula:
=SUM(INDEX(2:2,$B2):INDEX(2:2,$B2+$C2-1)
B2 contains the start cell/column; C2 contains the number of cells/columns.
Regards, TMS
Formula:=SUM(INDEX(2:2,$B2):INDEX(2:2,$B2+$C2-1)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks