Formulas needed - exclude data from sum if data in cells match & conditional formatting

[joshdog13]

I need a couple of formulas.

The first is for cell K62 of the "Paid Weekly Calculator" tab. The formula in K62 currently sums the data in column K for the range K9:K60. I need it to exclude any of the data in the sum formula in the range K9:K60 if any of the dates in column C in the range C9:C60 for the same row match any of the dates under "START DATE" in the orange section for "PAY PERIODS EXCLUDED".

With the sample data I have provided cells K11, K12, K18, K19, K23, K25, K28, K23, K25, K28, K31, K33, K34, K36, K37, K39, K41, K42, K44, K46, and K48 would be excluded from the total in K62. The correct sum without those cells should be $63,000.

The other formula I need will be a conditional formatting formula. I want to change the color to yellow any rows for only columns B-K where the date in column C for the range C9:C60 matches any of the dates under "START DATE" in the orange section for "PAY PERIODS EXCLUDED".

Thanks!!!