|The following is very ugly and very clunky.....|
I would advise NOT using this...
Find a different design for your spreadsheet but if you absolutely, positively need to keep it the way it is then here is a solution.
It can be configured differently, but I choose this way.
Row Number 1 should Have Headings that correspond to the contents of the columns, IE Column A should have heading of "Names"
If I read your post correctly your sheet should have the following basic design...
Column A = Employee Names
Column B = Events
Column C = Amounts to sum
If not, then you'll have to either change the formula, or change your sheet.
Enter the following information in the indicated cells:
Cell F2 First Employee Name
Cell F3 Second Employee Name
Cell F4 Third Employee Name
Cell F5 Fourth Employee Name
Cell G2 Event One, IE Vac.
Cell H2 Event Two, IE Overtime
Cell I2 Event Three, IE Sick
Cell J2 Event Four
Cell K2 Event Five
Cell L2 Event Six
Cell M2 Event Seven
We are going to build a matrix.
Cell F10 First Employee Name
Cell F11 Second Employee Name
Cell F12 Third Employee Name
Cell F13 Fourth Employee Name
Now comes the good part:
Cell G10 enter the formula:
Drag the formula Down the four names,
Drag the formula Across the seven events.
You should now have a matrix of Four Names and Seven Events with totals for all possible combinations.