Count and summarize text fields dcountda/pivot?
 

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