I want to use SUMPRODUCT on several columns that may have some #REF! errors.
Is this possible?

I've played around with
"=SUMPRODUCT(--(ISNUMBER(H64:H75)),--(ISNUMBER(G64:G75)))"
to get a feel for this function and it returns the correct number of rows
but I don't know how to get actual values for these ranges.

Thanks in advance,
Raul