Applying multiple formulas to multiple columns

I am very new to excel and am teaching myself "OJT". In an attempt to better track overtime by position, by hour, and by multiple reasons for overtime, I began creating this sheet. I have it nearly exactly as i want it, but cannot apply my formulas to other cells. I need to be able to input multiple letters that will track frequency by generating an updated total (if that makes sense). Cells B54 through B66 have the formulas I need. Currently they only apply to D4. I would like to apply them to all columns titled "code". Can and how is this possible?

Thanks in Advance!

In my opinion your best option is to reload the sheet with some examples in the different code areas ALONG WITH expected results.

(Thanks for the title change )

I agree that some sample data - and expected outcome - would help a lot.

My understanding is that you want a count of each reason code, and for each position, correct?

Also...
what are you trying to do with the formulas in B54:B66?
your SUM formula...=SUM(B10,E10,H10,K10,N10,Q10,T10,)...could be shortened to just =SUM(B10:T10). I doubt you would have values in Reason or Code in that row?

Please try B54

=SUMPRODUCT((LEN($A$3:$V$50)-LEN(SUBSTITUTE($A$3:$V$50,Sheet2!$A2,"")))*(LEFT($A$3:$A$50)="#")*($A$3:$V$3="code"))

Remove space after "A " at Sheet2!$A2

What's wrong with the formula?