Posted to microsoft.public.excel.misc

Peter[_14_] Peter[_14_] is offline

external usenet poster

Posts: 14

Calculating averages - Excel 2002

Good evening,

I'm using this formula to calculate monthly averages based on cell G3: =G3/MONTH(TODAY())
and it works fine if the year begins in January.
Is there a way to calculate the average if the year begins in say, March?

Regards

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating moving averages..	marcus lance	Excel Worksheet Functions	2	August 2nd 09 05:56 AM
Calculating averages for subgroups	PSmith	Excel Discussion (Misc queries)	1	November 22nd 07 05:09 PM
calculating averages	Golf Averages	Excel Discussion (Misc queries)	1	August 15th 05 08:25 PM
calculating strings (excel 2002)	student_hki	Excel Worksheet Functions	1	February 8th 05 09:57 PM
calculating averages	keving	Excel Worksheet Functions	8	December 9th 04 01:23 AM

All times are GMT +1. The time now is 03:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us