I am trying to use SUMIf with 2 conditions, I see someone else asked this
question before but I still can't get it to return anything other than #Value!

Can anyone help me?

=SUMPRODUCT(--('Raw Data'!F2:F60000="TEST");--('Raw
Data'!V2:V60000="Y");'Raw Data'!S1:S60000)

Column F and V contain text values and column S contains numerica values.
does this make a difference?

Thanks in advance....