Barb, that would fail for the same reason as the original did, ie the ranges
are not equal in size.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Barb Reinhardt" wrote in message
...
Try

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


"Louise" wrote:

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....