K
Kimbe
My question is...I have an Excel workbook with numerous sheets (one for each
week) and on each sheet I am entering a 5 day minimum sales amount (column C)
a 30 day minimum sales amount (column G) and a 90 day minimum sales amount
(column K). I am them going back at the end of the week, I am entering in
the actual sales amount for that week in columns F, J & N for the respective
period. I then have a column that produces the accuracy for the 5, 30 & 90
days (columns E, I & M). I want to do an Aggregate sheet with the accuracy
percentage for all the weeks combined. I am having a hard time coming up
with the formula. I thought I could take the accuracy column and average it
by the number of weeks but I guess you can't do an average of an average.
HELP!!!!! Any input would be greatly appreciated.
Kim
week) and on each sheet I am entering a 5 day minimum sales amount (column C)
a 30 day minimum sales amount (column G) and a 90 day minimum sales amount
(column K). I am them going back at the end of the week, I am entering in
the actual sales amount for that week in columns F, J & N for the respective
period. I then have a column that produces the accuracy for the 5, 30 & 90
days (columns E, I & M). I want to do an Aggregate sheet with the accuracy
percentage for all the weeks combined. I am having a hard time coming up
with the formula. I thought I could take the accuracy column and average it
by the number of weeks but I guess you can't do an average of an average.
HELP!!!!! Any input would be greatly appreciated.
Kim