Looking for a way to filter a text variable

Hi All,

I am working on totaling some data that has a text variable ( To Inv. ) that is messing with my formula (This is in the "Weekly OJR View" tab. I would like to sum column C (C11:C120) with everything but the cells that have the "To Inv." using the current referenced cells in cell C8. I would also like to sum everything that has the "To Inv." in column C9. I think all passwords have been removed in this, but the password is "schedule" without quotes in case there are any remaining.

Example:

To Inv./ 650
To Inv./ 186

Sum the 650 and 186 into Cell C9

1 / 3 and anything like this into cell C8

Thank you in advance,

Adam