Mike Punko

Posts: n/a

Average MTD percentage

Trying to setup a column to show the Month to Date average. My data sheet
looks like this. I also need this not to average 0.0% values

DATE RECOVERY MTD
1/1/05 95.4%
1/2/05 95.2%
1/3/05 92.3%
1/4/05 0.0%
1/5/05 91.2%

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
plotted Average	Micayla Bergen	Charts and Charting in Excel	4	July 15th 05 12:13 PM
Weighed Average of a weiged average when there are blanks	krl - ExcelForums.com	Excel Discussion (Misc queries)	1	July 6th 05 07:37 PM
What is this kind of average called?	havocdragon	Excel Worksheet Functions	3	June 24th 05 05:10 PM
calculate monthly average percentage of change	vikgarden	Excel Worksheet Functions	2	April 15th 05 07:38 PM
How do I create a formula to calculate the average percentage rat	LD	Excel Worksheet Functions	5	January 13th 05 06:17 PM

All times are GMT +1. The time now is 07:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us