Excel Data HELP!

[sgdunn]

I am trying to create a schedule for salaried employees; therefore, total time does not matter, rather the total DAYS worked. I would like an employee's total number of days worked separated into weekend and weekdays.
The format will be column "A" with days of the week and column "B" with the empolyees names.
ANY help would be greatly appreciated. ]

Thank you in advance.
Candace.

[Anne Troy]

You'll have to give us a little more than that, I think.

What column do you want to add or count?

Perhaps you just need sumif formulas.

See:

http://www.cpearson.com/excel/topic.htm

Look under Timesheets and also under sumif and countif to see if you find anything you like. He's got downloads too. Sounds to me like your setup is a little odd. Please don't take offense.

[Yogi Anand]

On 2002-05-19 10:44, sgdunn wrote:
I am trying to create a schedule for salaried employees; therefore, total time does not matter, rather the total DAYS worked. I would like an employee's total number of days worked separated into weekend and weekdays.
The format will be column "A" with days of the week and column "B" with the empolyees names.
ANY help would be greatly appreciated. ]

Thank you in advance.
Candace.

Hi sgdunn:
As Dreamboat suggested, more details would help. However I made some assumptions about the layout of your data, and I used the DCOUNT function. The criteria is in cells C1:E2, and the DCOUNT formulas are in cells C7 and E7. You enter the name in cell D7. The simulation shows number of weekdays and weekends worked by Bailey. If you set this up in your worksheet and you key-in Adams in cell D7, you will get days worked by Adams as 4 weekdays (cell C7), and 2 weekend days (in cell E7).
For a worksheet simulation see the following:

Microsoft Excel - Book1
D15		=
	A	B	C	D	E
1	DayOfWeek	Name	DayOfWeelk_wd	Name	DayOfWeelk_we
2	:alert('37389')>5/13/02	Adams	:alert('=OR(IF(WEEKDAY(A2)={3,4,5,6,7},1,0))')>FALSE	:alert('=D7')>Bailey	:alert('=OR(IF(WEEKDAY(A2)={1,2},1,0))')>TRUE
3	:alert('37390')>5/14/02	Bailey
4	:alert('37391')>5/15/02	Adams
5	:alert('37392')>5/16/02	Adams
6	:alert('37393')>5/17/02	Bailey	weekday	name	weekend
7	:alert('37394')>5/18/02	Adams	:alert('=DCOUNT($A$1:$B$10,1,$C$1:$D$2)')>3	Bailey	:alert('=DCOUNT($A$1:$B$10,1,$D$1:$E$2)')>0
8	:alert('37395')>5/19/02	Adams
9	:alert('37378')>5/2/02	Bailey
10	:alert('37379')>5/3/02	Adams
11
Sheet8

Click on a hyperlinked cell to see the underlying formula in the cell

You can also use the Advanced Filter for your problem, and other people on the board will probably have even more suggestions.

Regards!

[ This Message was edited by: Yogi Anand on 2002-05-19 13:12 ]

[ This Message was edited by: Yogi Anand on 2002-05-19 13:23 ]