please go thru the file....and help on it.
thanking you in advance
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):
then select N4 and drag fill down. Adjust the formula to reference the actual cells where you will specify the month numbers.