Hi!

What exactly do you want to do concerning the last 5 non-empty cells in the
column?

Count? Count what? What if there aren't 5 entries? Where is this data? What
cell does it start in?

Biff

"leafsfan1967"
wrote in message
news:leafsfan1967.1wnyuc_1128909907.2647@excelforu m-nospam.com...

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