Forum Discussion
Formula 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...
It's better to use
=SUM(E3:INDEX(E:E,ROW()-1))
and
=SUM(E69:INDEX(E:E,ROW()-1))With inserted row formula will be adjusted automatically
I used this formula and it worked great, thank you so much!!!!
=SUM(E69:INDEX(E:E,ROW()-1))
What was the difference between your formula with the INDEX and my formula with the INDIRECTor even OFFSET
=SUM(INDIRECT("E69:E"&ROW()-1))
Someone else even suggested =SUM(F69:OFFSET(F76,-1,0))