bethmsu96Copper ContributorSep 25, 2020Formula Help with Excel My spreadsheet has chronological info on rows 1-63 then starting on rows 66 and down is the same info but by agent. So I am running a sum up top with chronological data using =SUM(INDIRECT("E3:E"&ROW...Show MorePlease Help with Formula.xlsx23 KB
HansVogelaarMVPSep 25, 2020bethmsu96 You could use =SUM(E69:OFFSET(E76,-1,0)) and =SUM(F69:OFFSET(F76,-1,0))
