C
Curtis
I currently use the following formula below to caculate the number of days
worked
=SUMPRODUCT(('Employee Data'!$L$5:$L$260<>"")/COUNTIF('Employee
Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))
I need to add a string that calcualtes the number of different days worked
by each employee...referring to (for example) cell $a5 through $a48
Thanks
worked
=SUMPRODUCT(('Employee Data'!$L$5:$L$260<>"")/COUNTIF('Employee
Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))
I need to add a string that calcualtes the number of different days worked
by each employee...referring to (for example) cell $a5 through $a48
Thanks