What I would like to do is add up hours shown within specific columns or
ranges on multiple timesheets. But here's the tricky part, to add up only
those cells that have all the same number (i.e. job no.)in a different column
within that same row.
Example: One worksheet
Job                                                  Hours
601                                                    8
602                                                    16
601                                                    4
704                                                    11
408                                                    6
602                                                    7

Now to add up hours for each job no. on another totals worksheet:
Job       Total Hours
408            6
601            12
602            23
704            11

While at the same time having the cells on the total worksheet linked to the
source, so if I change or clear the hours cell or the job no. cell in the
source range, the totals reflect it.
Is there a way to do this? Please help.