Gp total

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:39 PM GMT

Question

gp


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

thanking you in advance


Mukesh


Answer

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.

Advertisement

©2021 eLuminary LLC. All rights reserved.