how to use sumproduct count a date range & exclude 7 different words from the range

Thanks for the 2nd way :-) And definitely thanks for the tip on not including column headers with the date range. I did not know that. I am very new to using these formulas. I appreciate your help!