How to sum cells that are colored with conditional formatting?

[Noxqss38242]

Have a cell range D7:AB36
Cells will randomly highlight based on another cell's entered data.
How can I auto sum each column's cells based on if that cell is highlighted with conditional formatting?
So essentially only sum the colored cells per column.

Thank you in advance!

 

[mart37]

What are the criteria to highlight the cells?
The criteria can you use in a SUMIF or SUMIFFS to sum your total.

 

[Noxqss38242]

There are 5 different criteria that when selected by a "Form Control Check Box" cells will highlight automatically so the coding is quite a bit.

=AND(D7=MAX(D$7:AB$36),$B$3=TRUE)

That one is one of the 5 different conditional formatting.
2 of the conditions are for the rows in the range, 2 conditions are for the columns in the range, and 1 condition is for the entire range.