Formula Help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calulating the number of days an employee works 6
Sumproduct error 2
Excel formula help for calculating freight. 2
Help Using a Combination Function 2
Can I put a cell reference in a sumproduct formula 2
Sumif apllying to all sheets in workbook 2
Vlookup or Hlookup does not work 1
Pivotting - T. Valko 1

Top