Help creating a tally - Formula help

[Arkellsparkle]

Hello,
I will try and explain what i'm trying to do and maybe you can help.

I have designed a rota in excel. I have also created a tally of how many shifts the staff have each week.

I would like a formula that if I type a shift into a box it then adds to the tally. Is this possible?

Thank You for your help!

 

[Gerald Higgins]

Hi, welcome to the board.

This is probably do-able, but your request is so vague that it's virtually impossible to give a precise answer on how to do it.

Can you explain exactly what you want to do in more detail please ?

Don't worry about explaining what is going on in your workplace, just focus on the data that you have in your spreadsheet, how exactly it is layed out, and what exactly you want to do with it.