Grouping and summing with r
You were very close. Just switch the first two input arguments.

&gt; aggregate(directLaborNov18['Actual_work'], directLaborNov18[c('Employee')],  sum)
   Employee Actual_work
1   Joe Smo          20
2 Sam Adams          15