I'm not really good with excel formulas yet, but I do know the below is
true. Do not average averages and percents - use the acual numbers..





DCSwearingen Wrote:
I do a lot of Key Indicators requiring Daily, WTD, MTD, & YTD
percentages.

You have to be careful of averaging averages and percents. This would
be OK if all had equal weighting, but not if they are differing in
magnitude, particularly the magnitude of individual divisors.




--
redneck joe


------------------------------------------------------------------------
redneck joe's Profile: http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=568776