AVERAGE / OFFSET FUNCTIONS, TODAY..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an equation can't quite figure out. Will take advice on how to setup
if I am on wrong track. Trying to get a running average over a 2 day period
(if can? using same 2 cells for each subsequent day for input, in same row).

For now example is in column format.
cell E4, enter number: 2
cell E5, enter: =AVERAGE(OFFSET(B5,-E$4+1,0,E$4,1))
and drag down a few rows.
in cell B5 "down", can put sequential numbers: 1, 2, 3, 4...

The above works as intended. What I need is to only use 2 cells in "B"
column, so equation only goes back 1 day? you get it..

Equation dragged down shows 3 results, before #DIV/0!
Example: need to put Input for, monday, in 1st cell (B5), tues in cell B6,
BUT wed uses cell B5. Is that possible?
Result needed is for a 2 day average: "Up" or "Down" to show in 1 cell.

Don't know where to start on equation. Do I need something like TODAY(), or
will a minus 1 somewhere work..
Other idea was a 5 day & WEEKDAY / WORKDAY, would be nice to figure out, but
may be more days than can use now.
Thanks for Help...
 
What am I missing here?

If you're going to continually use *only* B5 & B6, alternating between them
each day,
What's wrong with:

=AVERAGE(B5:B6)

If you're entering data all the way down Column B, one cell per day,
The exact, same formula, copied down Column E, would *still* give you 2 day
averages,
consecutively.

Care to elaborate on your question?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

I have an equation can't quite figure out. Will take advice on how to setup
if I am on wrong track. Trying to get a running average over a 2 day period
(if can? using same 2 cells for each subsequent day for input, in same row).

For now example is in column format.
cell E4, enter number: 2
cell E5, enter: =AVERAGE(OFFSET(B5,-E$4+1,0,E$4,1))
and drag down a few rows.
in cell B5 "down", can put sequential numbers: 1, 2, 3, 4...

The above works as intended. What I need is to only use 2 cells in "B"
column, so equation only goes back 1 day? you get it..

Equation dragged down shows 3 results, before #DIV/0!
Example: need to put Input for, monday, in 1st cell (B5), tues in cell B6,
BUT wed uses cell B5. Is that possible?
Result needed is for a 2 day average: "Up" or "Down" to show in 1 cell.

Don't know where to start on equation. Do I need something like TODAY(), or
will a minus 1 somewhere work..
Other idea was a 5 day & WEEKDAY / WORKDAY, would be nice to figure out, but
may be more days than can use now.
Thanks for Help...
 
Hi! thanks. If average works, may be simple answer. Equations new for me..
maybe getting caught up in them.. will need to know if 2 days prior average
is less or more than todays output.. sounds like that will work ha.. thanks..
 
Back
Top