P
Praveen Potturi
Hi,
Can anyone help in doing sum of daily data with respect to weekdays. I want
to get the sum of everydays data as week1, week2..etc. for that month
Example:-
A B C D E
1 Task Type 1-Jul 2-Jul 3-Jul 4-Jul
2 Break 0:00:00 0:00:00 0:00:00 0:00:00
3 Meeting 0:00:00 0:00:00 0:00:00 0:00:00
4 Training 0:00:00 0:00:00 0:00:00 0:00:00
5 Mentoring 0:00:00 0:00:00 0:00:00 0:00:00
6 Celebrations 0:00:00 0:00:00 0:00:00 0:00:00
7 System Dow 0:00:00 0:00:00 0:00:00 0:00:00
8 Surplus 0:00:00 0:00:00 0:00:00 0:00:00
9 Total 0:00:00 0:00:00 0:00:00 0:00:00
10
11
12
13 Week1 Week2 Week3 Week4
14 Break
15 Meeting
16 Training
In the above example I want a formula in B14, C14, D14, E14 which can do sum
of weekdays (B2+C2+D2+E2) according to week1, week2 week3 so that i don't
have to map it everytime manually. I want excel to recongnize the data
according to the dates in B1, C1, D1.
So if dates in B1, C1 D1 are weekdays of 1st week then it should sum of
B2+C2+D2 and result should show in B14.
Can anyone help in doing sum of daily data with respect to weekdays. I want
to get the sum of everydays data as week1, week2..etc. for that month
Example:-
A B C D E
1 Task Type 1-Jul 2-Jul 3-Jul 4-Jul
2 Break 0:00:00 0:00:00 0:00:00 0:00:00
3 Meeting 0:00:00 0:00:00 0:00:00 0:00:00
4 Training 0:00:00 0:00:00 0:00:00 0:00:00
5 Mentoring 0:00:00 0:00:00 0:00:00 0:00:00
6 Celebrations 0:00:00 0:00:00 0:00:00 0:00:00
7 System Dow 0:00:00 0:00:00 0:00:00 0:00:00
8 Surplus 0:00:00 0:00:00 0:00:00 0:00:00
9 Total 0:00:00 0:00:00 0:00:00 0:00:00
10
11
12
13 Week1 Week2 Week3 Week4
14 Break
15 Meeting
16 Training
In the above example I want a formula in B14, C14, D14, E14 which can do sum
of weekdays (B2+C2+D2+E2) according to week1, week2 week3 so that i don't
have to map it everytime manually. I want excel to recongnize the data
according to the dates in B1, C1, D1.
So if dates in B1, C1 D1 are weekdays of 1st week then it should sum of
B2+C2+D2 and result should show in B14.