Sum an offset range where column criteria met.

Hi All,

I'm hoping someone could kindly assist with a small issue I have? Unfortunately I have not been able to collaborate the correct formulas to get the results I need.

Brief:-
I have a sheet that contains figures for a number of agencies that run from month 1 to 12. The order that each agency can appear can differ each time the report is ran.

The user can enter the current month number in to a cell on which another cell calculates the YTD (sum from month 1 to the user entered cell).

Therefore, the formula would need to be able to identify the client name within a row, offset and sum the required months. Hope this makes sense, I have attached a quick spreadsheet I have knocked together displaying how the information will be displayed.

Again, any help on this would be very much appreciated.

Thanks for your time.


Stu

Thanks for the response XOR LX,

The added problem I have is that Agency 1 and Agency 2 could swap positions when the report is ran. Is there a way to incorporate this so that the formula dynamically sums the correct agency no matter which order it appears?

Thanks

Stu

Hi guys,

Spot on, two different answers that acheive the same goal.

Thanks

Stuart