Count and summarize text fields dcountda/pivot?
- From: rispalt@xxxxxxxx
- Date: 5 Nov 2005 09:23:00 -0800
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
.
- Prev by Date: Re: highlight row
- Next by Date: Re: Linking worksheets and the formula shows up instead of the answer
- Previous by thread: Re: A parent spreedsheet problem
- Next by thread: Re: Linking worksheets and the formula shows up instead of the answer
- Index(es):
Relevant Pages
|