I am trying to figure out how to find the total trainers working in same hour, and needs to be able to change when a trainer is added or removed. Example at the bottom of table in red. Below is how my spreadsheet is set up. I am new to the mrexel forum and not an expert by any means with excel, so not sure how this works, and greatly appreciate help with this. Thank you
[TABLE="width: 680"]
<tbody>[TR]
[TD]8:00 AM[/TD]
[TD]9:00 AM[/TD]
[TD]10:00 AM[/TD]
[TD]11:00 AM[/TD]
[TD]12:00 PM[/TD]
[TD]1:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]totals[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]AM[/TD]
[TD]PM[/TD]
[/TR]
[TR]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]no trainer[/TD]
[TD]trainer 2[/TD]
[TD][/TD]
[TD]no trainer[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD]no trainer[/TD]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD][/TD]
[TD]trainer 2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]no trainer[/TD]
[TD]Trainer 5[/TD]
[TD][/TD]
[TD]trainer 3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD][/TD]
[TD]Trainer 5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]trainer 9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]trainer 10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2:00 PM[/TD]
[TD]3:00 PM[/TD]
[TD]4:00 PM[/TD]
[TD]5:00 PM[/TD]
[TD]6:00 PM[/TD]
[TD]7:00 PM[/TD]
[TD][/TD]
[TD]trainer 11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD][/TD]
[TD]trainer 13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD][/TD]
[TD]trainer 14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]Trainer 15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 18[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 19[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]8:00 AM[/TD]
[TD]9:00 AM[/TD]
[TD]10:00 AM[/TD]
[TD]11:00 AM[/TD]
[TD]12:00 PM[/TD]
[TD]1:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2:00 PM[/TD]
[TD]3:00 PM[/TD]
[TD]4:00 PM[/TD]
[TD]5:00 PM[/TD]
[TD]6:00 PM[/TD]
[TD]7:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 680"]
<tbody>[TR]
[TD]8:00 AM[/TD]
[TD]9:00 AM[/TD]
[TD]10:00 AM[/TD]
[TD]11:00 AM[/TD]
[TD]12:00 PM[/TD]
[TD]1:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD]totals[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD]trainer 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]AM[/TD]
[TD]PM[/TD]
[/TR]
[TR]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]trainer 2[/TD]
[TD]no trainer[/TD]
[TD]trainer 2[/TD]
[TD][/TD]
[TD]no trainer[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]trainer 3[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD]no trainer[/TD]
[TD]trainer 4[/TD]
[TD]trainer 4[/TD]
[TD][/TD]
[TD]trainer 2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]Trainer 5[/TD]
[TD]no trainer[/TD]
[TD]Trainer 5[/TD]
[TD][/TD]
[TD]trainer 3[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]trainer 6[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD][/TD]
[TD]Trainer 5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 7[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 8[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]trainer 9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]trainer 10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]2:00 PM[/TD]
[TD]3:00 PM[/TD]
[TD]4:00 PM[/TD]
[TD]5:00 PM[/TD]
[TD]6:00 PM[/TD]
[TD]7:00 PM[/TD]
[TD][/TD]
[TD]trainer 11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD]trainer 7[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 12[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD]trainer 8[/TD]
[TD][/TD]
[TD]trainer 13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD]trainer 9[/TD]
[TD][/TD]
[TD]trainer 14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]trainer 10[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]Trainer 15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 18[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 19[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD]trainer 20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD]no trainer[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]8:00 AM[/TD]
[TD]9:00 AM[/TD]
[TD]10:00 AM[/TD]
[TD]11:00 AM[/TD]
[TD]12:00 PM[/TD]
[TD]1:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2:00 PM[/TD]
[TD]3:00 PM[/TD]
[TD]4:00 PM[/TD]
[TD]5:00 PM[/TD]
[TD]6:00 PM[/TD]
[TD]7:00 PM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]