Mismatch for Sumproduct

[mikejo]

Thank you, changed. Follow up on the topic: Even if I reduce the formula to something simpler, I still get mismatch:

WorksheetFunction.SumProduct( _        
        (ws.Range("AX2:AX" & lRow) = "value") * _
        (ws.Range("R2:R" & lRow) = "value") * _
        (ws.Range("AC2:AC" & lRow)))

Tested the 2 values in quotes to be present in their respective columns, while AC a column full of numbers