Would be nice if you told us more about the workbook. Like were is the data
for each day of the week? - on the same worksheet or on its own worksheet.
Tell us what we need to help you.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"blackgold21" wrote in message
...
I have built a workbook in which I have inserted a formula to tell me
whether
the contents of a supply bin needs replenishment or not. The formula I
used
is: =IF(E3F3,"REPLENISH!","No Action"). Each morning, I run a report to
see
what parts have been used, which becomes a new sheet in the workbook.

Now, I want to add a formula that, whenever it sees "REPLENISH!," it will
back through the workbook to count whether that same part needed
replenishment on consecutive previous days. If it has, then the latest
worksheet will report the number of days that part that part has been in
need
of replenishment.

Can you help me?