Code:
NameOfJob       Subcat1 Subcat2 Subcat3 JobCaptain JobAssistant1 JobAssistant2           bob     sam     jerry   cindy   jane

(Jobname1)      3       3       3       bob                                               9 
(Jobname2)      65      4       32      sam                       cindy                          50.5            50.5
(Jobname3)      4       34      21      jerry      bob            jane                   19.66           19.66           19.66
(Jobname3)      4       34      21      jerry                                                            59
(Jobname3)      4       34      21      jerry                                                            59
                                                                                         28.67   50.50  137.67   50.50   19.67

        cell  i6  >>>   IFERROR(IF(SEARCH(I$4,($E6&$F6&$G6)),SUM($B6:$D6)/COUNTA($E6:$G6),""),"")


cell i6 in this example is the cell containing 9 just under bob. That formula is copied throughout the cells in the tally columns.


Edited by gbeer (02/04/2010 03:55)
_________________________
Glenn