Average formula

[onyx4813]

What formula do I use to calculate a weekly average as the monthly total changes?
Example: july total value divided by 28weeks, august value divided by 32 weeks, sept value divided by 36 weeks and so on
In other words, a weekly average as each month ends and the value is entered
I hope someone understands this and can help
thanks so much
leslie

[Bob Phillips]

Assuming the dates are in say column A and the amounts in B, you can do a
running average with

C2: =AVERAGE($B$2:B2)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)


"onyx4813" <[email protected]> wrote in
message news:[email protected]...
>
> What formula do I use to calculate a weekly average as the monthly total
> changes?
> Example: july total value divided by 28weeks, august value divided by
> 32 weeks, sept value divided by 36 weeks and so on
> In other words, a weekly average as each month ends and the value is
> entered
> I hope someone understands this and can help
> thanks so much
> leslie
>
>
> --
> onyx4813
> ------------------------------------------------------------------------
> onyx4813's Profile:
http://www.excelforum.com/member.php...o&userid=26305
> View this thread: http://www.excelforum.com/showthread...hreadid=471373
>

[Matthew S]

Forgive me! This has nothing to do with the original question. But, I'm
stuck and I don't know how to proceed. I can’t get to a point where I can
actually ask my own questions.

I click new question and my browser just thumps.

How do I generate my own question? Or, where can I go for help with this
problem?


"Bob Phillips" wrote:

> Assuming the dates are in say column A and the amounts in B, you can do a
> running average with
>
> C2: =AVERAGE($B$2:B2)
>
> and copy down
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "onyx4813" <[email protected]> wrote in
> message news:[email protected]...
> >
> > What formula do I use to calculate a weekly average as the monthly total
> > changes?
> > Example: july total value divided by 28weeks, august value divided by
> > 32 weeks, sept value divided by 36 weeks and so on
> > In other words, a weekly average as each month ends and the value is
> > entered
> > I hope someone understands this and can help
> > thanks so much
> > leslie
> >
> >
> > --
> > onyx4813
> > ------------------------------------------------------------------------
> > onyx4813's Profile:
> http://www.excelforum.com/member.php...o&userid=26305
> > View this thread: http://www.excelforum.com/showthread...hreadid=471373
> >
>
>
>

[Bob Phillips]

LOL. I thought at first you were saying my answer had nothing to do with the
original question.

I have no answer to your problem as I don't use the web portals. I find it
easier to connect direct to the newsgroups via a newsgroup reader.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matthew S" <[email protected]> wrote in message
news:[email protected]...
> Forgive me! This has nothing to do with the original question. But, I'm
> stuck and I don't know how to proceed. I can't get to a point where I can
> actually ask my own questions.
>
> I click new question and my browser just thumps.
>
> How do I generate my own question? Or, where can I go for help with this
> problem?
>
>
> "Bob Phillips" wrote:
>
> > Assuming the dates are in say column A and the amounts in B, you can do
a
> > running average with
> >
> > C2: =AVERAGE($B$2:B2)
> >
> > and copy down
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "onyx4813" <[email protected]> wrote
in
> > message news:[email protected]...
> > >
> > > What formula do I use to calculate a weekly average as the monthly
total
> > > changes?
> > > Example: july total value divided by 28weeks, august value divided by
> > > 32 weeks, sept value divided by 36 weeks and so on
> > > In other words, a weekly average as each month ends and the value is
> > > entered
> > > I hope someone understands this and can help
> > > thanks so much
> > > leslie
> > >
> > >
> > > --
> > > onyx4813
> >
> ------------------------------------------------------------------------
> > > onyx4813's Profile:
> > http://www.excelforum.com/member.php...o&userid=26305
> > > View this thread:
http://www.excelforum.com/showthread...hreadid=471373
> > >
> >
> >
> >