Hi there

I'm hoping someone can steer me on the right path with this.

I'm pretty much a novice at Excel and I'm struggling with the following:

I am working at putting together a rota and want it to do several calculations for me to make life a little easier! Here is a screenshot to show how it looks:

Rota Screenshot.jpg

I want the occurrences of the following letters to be counted up from B2:Z2 (and so on) and the total divided by 2 (to give an hourly figure): M, TB, T, L, U, C, 1

I want the total to be included in column AE.

Can someone share their wisdom please?

Any help is really appreciated.

Cheers