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

Try in C8:

Formula:

Please Login or Register  to view this content.

And in C9:

Formula:

Please Login or Register  to view this content.

In your example, this is OK, but you may need a different approach if you also need to sum the values when there is text after the fraction, like in OJR DATA!F200

Please check if this will help you.

Good luck!