| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Average formula
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 |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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 |
|
#3
|
|||
|
|||
|
Forgive me! This has nothing to do with the original question. But, I'm
stuck and I don't know how to proceed. I cant 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" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
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" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to average certain times | Excel Discussion (Misc queries) | |||
| Average Formula | Excel Discussion (Misc queries) | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Hybrid Mode
