Dear Excel genius people,
Thanks in advance once again as I need your awesome expertise.
I have a number of activities (8 in total) each one represented by a letter.
For each date I have two sessions which one given person will be allocated one activity (letter). So each date has two cells which can be different activities.
I was wondering if there is a formula that would allow me to input letters in each cell for the dates and give me a total for each activity.
Example
Capture.PNG
Cheers!
Bookmarks