Help with formula
I would do it slightly differently, use the code name not value
=COUNTIF(B:B,INDEX(I:I,MATCH("Projects",J:J,0)))
where I holds the job code, J the job names, and B the job code against
time.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Gary''s Student" wrote in message
...
You only need a single column, say column B:
2
2
3
2
2
1
1
2
then
=COUNTIF(B1:B8,"=2") will yield 5 the number of increments for projects
(code#2)
use "=1", etc. for the other codes.
--
Gary's Student
"Mike Busch" wrote:
We have a worksheet that we use for time management. It has the day's of
the
week vertically, with 15 minute increments. To the left is a list from 1
to
10 on the possible job duties we would place in the time slots. I would
like
to have a formula that would tell me how many each of a particular job
duty I
would spend on during the day. Example.
1 E Mail
2 Projects
3 Quotes
4 research
And so on...
7:00 - 2
7:15 - 2
7:30 - 3
7:45 - 2
8:00 -2
8:15 - 1
8:30 - 1
8:45 - 2
And so on...
I would like to select the range and tell me how many times a particular
job
appears in a day. thanks.
|