Gp total

QuestionEdit

please go thru the file....and help on it.

thanking you in advance

Mukesh

AnswerEdit

Mukesh,

Assume the row with the numbers 1, 2, 3, . . . indicating the month are in row 2 cells B2:M2

so 77197 is in cell A4 From is in cell C7 with 2 in cell D7 To is in cell C8 with 6 in cell D8

so to show the total from May (2) to Sep (6) inclusive for Agent 77197 (row 4):

N4: =SUM(OFFSET($A4,0,$D$7,1,$D$8-$D$7+1))

then select N4 and drag fill down. Adjust the formula to reference the actual cells where you will specify the month numbers.