Hey all,

Having a typical Monday morning here. I have what I assume is an easy
question but I can't get my brain around it.

I have a range of dates (A1:A22) for which I have a value (C1:C22
actuals formula reference to B1:B22) assigned to each. This data is
input each day. In D1:D22 I have a value that represents a "goal" to
reach for each day. This remains constant to meet the SLA with our
client.

What I would like to do is in E1:E22 is to have a formula that will
determine what tomorrow's "goal" should be based on the Actuals in B if
the constant in D remains the same for the remainder of the days. So,
AVERAGE what actuals we have with the constant for all days except
tomorrow and determine what tomorrow's goal should be to meet the
AVERAGE for the total days.

Hope that is clear. Any help is much appreciated.

Thanks
Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=551028