Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Formula Help

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