Sum offset formula for Horizontal data

[arshad_masud]

Dear Hui


How can we get sum of figures horizontally by using sum offset formula.


e.g. i have this kind of data


Months

Jan Feb Mar Apr May

100 200 120 50 340


I know the use of this formula if the data is Verticle.


Thanks in advance.

 

[Hui]

Assuming the above data is in B1:F2

and the month you want to add up to is in A3

This will work

=SUM(OFFSET(B2,,,,MATCH(A4,B1:F1,0)))

 

[arshad_masud]

Thanks Hui