SUMPRODUCT formula is summing text and I want it to stop doing that

[nathan.grant]

Hello,

I am trying to use SUMPRODUCT in a formula in order to sum a specific range when I filter the data.

Unlike my SUMIF function, SUMPRODUCT is counting text labeled "Unknown" in my range.

How do I get it to stop doing that? I tried ISNUMBER, but I keep getting an error, indicating that I am not getting it quite right in relation to the syntax.

Is there another way to solve the problem?

Here is the formula: SUMPRODUCT(--(C3:C38241>=25),SUBTOTAL(109,OFFSET(H3:H38241,ROW(H3:H38241)-MIN(ROW(H3:H38241)),0,1)))

 

[nathan.grant]

Oh, just to be clear, the range C3:C3824 is a list of numbers. The range H3:H38241 has a value of 1 in each cell to allow summing.

The formula is attempting to sum H3:H38241 for those values in C3:C3824 that are greater than or equal to 25, except that I don't want it to sum H3:H38241 for cells in C3:C3824 marked as "Unknown."

My attempts at excluding the "unknown" value thus far have been unsuccessful.

 

[nathan.grant]

Oh, just to be clear, the range C3:C3824 is a list of numbers. The range H3:H38241 has a value of 1 in each cell to allow summing.



The formula is attempting to sum H3:H38241 for those values in C3:C3824 that are greater than or equal to 25, except that I don't want it to sum H3:H38241 for cells in C3:C3824 marked as "Unknown."



My attempts at excluding the "unknown" value thus far have been unsuccessful.

Someone else solved this one on a different forum.

The answer was to create another set of parens with --
=SUMPRODUCT(--(C3:C38241>=25),--(C3:C38241<>"Unknown"),SUBTOTAL(109,OFFSET(H3:H38241,ROW(H3:H38241)-MIN(ROW(H3:H38241)),0,1)))