Thank you again icestationzbra.

The improvement in calculation time by switch to the COUNTIFS instead of SUMPRODUCT is HUGE!

A recalculation of my entire sheet used to take between 15-20 minutes and now with the modifications it takes ~1 minutes...this is a 15-20x improvement!