View Single Post
  #1   Report Post  
tzvarza`
 
Posts: n/a
Default sum of last 7 numbers


I have a row where I enter a number every day. I need a cell which shows
the sum of the last 7 entered numbers.

For example, if I have the numbers 7 2 4 11 5 4 2 6, the cell must show
28 (11+5+4+2+6)


--
tzvarza`
------------------------------------------------------------------------
tzvarza`'s Profile: http://www.excelforum.com/member.php...o&userid=28765
View this thread: http://www.excelforum.com/showthread...hreadid=484523