Greg has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Offset function
Please can you advise how I can sum the 12 cells to the right of a specific cell when the specific cell is found using a match/index function?
Thanks,
Greg
RE: Offset function
Hello Greg,
Hope you enjoyed your Microsoft Excel courses with Best STL.
Thank you for your question regarding summing cells to the left of a cell value having been produced using a match/index function.
It would help if you could send a sample file showing the data as described and explain where you wish to place the sum result. I will take a look at this and come back to you with an answer.
My email is: rl@stl-training.co.uk
I look forward to your reply.
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
RE: Offset function
Hi Greg
Just checking if your question about summing 12 cells to the right of a specified cell was answered.
In a macro you can include
ActiveCell.FormulaR1C1 = "=SUM(RC[1]:RC[12])"
which will sum 12 cells to the right of the active cell.
Not using a macro the OFFSET function could be used (in Excel 2010) to do a similar thing. For example
=SUM(OFFSET(B1:M1,0,1))
will sum the 12 cell to the right of A1.
Please let us know where the index/match function fits in if you need further help.
Regards
Doug Dunn
Best STL
RE: Offset function
Thanks Doug, I managed to figure it out in the end.
Regards,
Greg
RE: Offset function
That's good. Well done!
Doug
