Hi there,
I have 2 sheets. sheet a contains monthwise data like

apr may jun july aug sept oct nov dec jan feb mar cum
1 2 3 4 5 6 7 8 9 10 11 12 78
I need a formula which sums horizontally (month wise) basing on the month
condition which sheet "b" contains in a1 cell. May be the following example
will explain a little better
sheet B (Cell A1=Nov)
cell b1 = the formula which sums up from apr to nov

Thanks in advance