Calulating the number of days an employee works

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curtis - 29 Oct 2006 19:25 GMT

I currently use the following formula below to caculate the number of days
worked by each emloyee

=SUMPRODUCT(('Employee Data'!$L$5:$L$260<>"")/COUNTIF('Employee
Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))

However this formulae was used when each employee information was seperated
in seperate sheets.

I need to add a string to this fomrula that calcualtes the number of
different days worked by each employee (all employee information is now
compiled in a single sheet

Hopefully this make s sense

Thanks

ce

Reply to this Message

excelent - 29 Oct 2006 19:54 GMT

I ned to no where employeenames are (ges there names are in several rows)?
and u ned to have the names somwhere only onse to calcuate with

"Curtis" skrev:

> I currently use the following formula below to caculate the number of days
> worked by each emloyee
[quoted text clipped - 14 lines]
>
> ce

Reply to this Message

Curtis - 29 Oct 2006 20:06 GMT

Employee Names are located in the sheet and range

('Employee Data'!$J$5:$J$260=$A24)

Where $a24 = unique employee ID

> I ned to no where employeenames are (ges there names are in several rows)?
> and u ned to have the names somwhere only onse to calcuate with
[quoted text clipped - 19 lines]
> >
> > ce

Reply to this Message

excelent - 29 Oct 2006 21:15 GMT

OK put all employeenames in colum eg. N5:N? only onse
then put this formula in O5 and copy down for all employee i column N

=SUMPRODUCT(($J$5:$J$260=N5)*($L$5:$L$260))

"Curtis" skrev:

> Employee Names are located in the sheet and range
>
[quoted text clipped - 25 lines]
> > >
> > > ce

Reply to this Message

Curtis - 30 Oct 2006 02:12 GMT

Sorry I am not sure I provided enough detail

I need the formula to be able to distiguish between employee ID and
different days worked. AN employee can represent multiple instances of work
in the same day

SO far I have

SUMPRODUCT(('Employee Data'!$L$5:$L$260<>"")/COUNTIF('Employee

> > > > Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))

but that just tells me the nunber of different days in total and does not
seperate by employee

Thanks

ce

> OK put all employeenames in colum eg. N5:N? only onse
> then put this formula in O5 and copy down for all employee i column N
[quoted text clipped - 32 lines]
> > > >
> > > > ce

Reply to this Message

excelent - 30 Oct 2006 05:39 GMT

ned more info
back after work later today

"Curtis" skrev:

> Sorry I am not sure I provided enough detail
>
[quoted text clipped - 50 lines]
> > > > >
> > > > > ce

Reply to this Message

Bob Phillips - 30 Oct 2006 10:43 GMT

=SUMPRODUCT(($J$5:$J$12=A24)*($L$5:$L$12<>"")/COUNTIF($L$5:$L$12,$L$5:$L$12&
""))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Sorry I am not sure I provided enough detail
>
[quoted text clipped - 50 lines]
> > > > >
> > > > > ce

Reply to this Message