cell a1 : "DAY 1"
cell a2 : "DAY 2" etc.
cell a50 : "DAY 50"

the formula will be :
=SUM(OFFSET(A1:A50,ROWS(A1:A50)-4,0,5,1))

"leafsfan1967" wrote:


Let's say I've got several rows of data for one column updated each day
downward.

DAY 1
DAY 2
DAY 3
DAY 4
DAY 5
EMPTY
EMPTY
etc...

So each day, I add on so the next cell in the above example would be
DAY 6. Now, my dilema is that I only want to count the most recent 5
cells. For example, if I went all the way down to DAY 100, I would only
want to count DAY 96 through DAY 100. I have no idea how to use this
sort of concept in a sumif or countif formula.

Any help would be appreciated.


--
leafsfan1967
------------------------------------------------------------------------
leafsfan1967's Profile: http://www.excelforum.com/member.php...o&userid=24357
View this thread: http://www.excelforum.com/showthread...hreadid=474644