Average formula

O

onyx4813

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

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)
 
M

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 said:
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)
Click to expand...
 
B

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)
 
Top