Hi there! Yes, there is a way to make SUMPRODUCT ignore text when evaluating. You can use the ISNUMBER function to check if each cell in the sum range contains a number or not. Here's how you can do it:

1. In a blank cell, enter the formula =ISNUMBER(A1), where A1 is the first cell in your sum range.
2. Copy the formula down to all the cells in the sum range.
3. Now, in your SUMPRODUCT formula, replace the sum range with the range of cells containing the ISNUMBER formulas. For example, if your original formula was =SUMPRODUCT(A1:A10,B1:B10), and your ISNUMBER formulas are in cells C1:C10, your new formula would be =SUMPRODUCT(C1:C10,B1:B10).

By using the ISNUMBER function, any cell in the sum range that contains text will return a FALSE value, which will be treated as a zero in the SUMPRODUCT calculation. This way, the text will be ignored and only the numbers will be added up.