Employee special timesheet help

[bramhawk]

Dear excel pros,

I'm doing an excel file for the company i work for.
The point is to see how many times a certain person leaves at 8 on a friday, leaves at 9 on friday, leaves at 8 on saturday and has saturday off.
There's a general page which looks like this:

general.png

Numbers in the far left column represent a certain person. colored cell represents all the factors mentioned above(friday 8pm, ...). more years are supposed to be added later.

Then there's a page per year:

year.png

Same setup, per person. Now it's set in weeks, goes on like this for 52 weeks (one year) per page/year.

Person filling in this list, will be putting a 1 next to each person in the right column, every week. Now I need to have each column with same main factor, like friday to 8pm, added up per person, so it can be posted on general page in the right cell.
I hope everyone understands what I'm trying to reach. Did i do something wrong already or ... ?
I know I can manually do the sum of each and every cell by manually clicking it and adding it into a formula on the general page, but that leaves room for error.

Any better, more efficient way to do this?

Thanks for the help!

[JohnTopley]

Please post an excel file (not image) showing some expected results.

To upload a file click "Go advanced2 then scroll down to "Manage attachments"

[bramhawk]

Done, this is the file I've been working on, pretty straightforward

[bramhawk]

So i thought about it and was wondering if i could give cells a name..

So i could do something like this

if row is x and cellname is y then add those

Is this possible? If so, can someone give me a correct formula for this?

Thanks
Bram