Hi,
I am new to advamced excel, any other then sum of colums
I am helping a friend to make a planning scheme fo here shop, monday -
sunday.
A list of fixed tasks distributed between 10 employee 9-21
monday-sunday.
I'd like to summarize the distribution of task/day, task/week on a
total and
per emplouee (A,B,C,D..).
task is represented below by k1,sk,fg. count(task) x 1/4 hour =
time/task.
I have tied DCOUNTA and pivot table but did not manage
Any help is appriciated! I have the feeling it's basic for you guros
Lars
mon tue wed ...
Tid A B A D A B
9:00 k1 sk k1 sk k1 sk
9:15 k1 sk k1 sk k1 sk
9:30 k1 sk k1 sk k1 sk
9:45 k1 sk k1 sk k1 sk
10:00 fg k1 fg k1 fg k1
10:15 fg k1 fg k1 fg k1
10:30 fg k1 fg k1 fg k1
10:45 fg k1 fg k1 fg k1
OUTPUT WANTED:
Monday:
k1 sk fg....
A
B
C
TOTAL
Tuesday:
k1 sk fg....
A
B
C
TOTAL
Total (1 week)
k1 sk fg....
A
B
C
TOTAL
Bookmarks