Calculating Pivot Table values across rows

Riny,

First and foremost, I appreciate your willingness to help. Thank you.

I've attached a copy of our spreadsheet: Competition Submissions Log.v2.Final.2023072 TEST FILE. I know how challenging it is to read someone else's code, so let me explain a little bit.

This spreadsheet is for logging competition submissions for my Camera Club. The Coordinator enters data in the "NBCC Competition Log" as he/she receives entries from photographers. The data is summarized in three Pivot Tables on the righthand side. Clicking the "Update Tables" icon refreshes the Tables. Upon refreshing the Tables in the worksheet is locked; there is no password, so to unlock simply select Review > Unprotect Sheet.

The Board has recently made changes to the Requirements. Competitors are now permitted to enter a total of 3 entries each month, but no more than 2 in each "Competition Type (Electronic or Print)." The "Competitors Summary Table" shows the number of competitions entered and the total number of submissions for each competitor. If a competitor submits more than 3 entries the "Overage" column highlights the number of excessive entries.

I will try to attach the TEST FILE mentioned above, but I don't see a way to attach it. Perhaps after I hit Post I will see an option; otherwise, perhaps you can help.

If you need more information, please do not hesitate to contact me. Thanks in advance.