• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum offset formula for Horizontal data

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.
 
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)))
 
Back
Top