G
Guest
Hi all,
It's been a while but I have a new problem. I have 3 columns as follows:
A B C
Date Day Quantity
1-May Tuesday 34,725
2-May Wednesday 38,601
3-May Thursday 40,115
4-May Friday 34,505
5-May Saturday 12,280
6-May Sunday 0
7-May Monday 0
8-May Tuesday 42,044
and so on for the month. What I need to calculate is the following....
calculate the average for a weekday so that I can give an estimate for the
month and also the same for Saturdays. The idea being that I can estimate
the total amount expected for the month based on current data for the month
to date. The average cannot include days with 0 as this could be a non
working day.
regards
It's been a while but I have a new problem. I have 3 columns as follows:
A B C
Date Day Quantity
1-May Tuesday 34,725
2-May Wednesday 38,601
3-May Thursday 40,115
4-May Friday 34,505
5-May Saturday 12,280
6-May Sunday 0
7-May Monday 0
8-May Tuesday 42,044
and so on for the month. What I need to calculate is the following....
calculate the average for a weekday so that I can give an estimate for the
month and also the same for Saturdays. The idea being that I can estimate
the total amount expected for the month based on current data for the month
to date. The average cannot include days with 0 as this could be a non
working day.
regards