software

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=quot;TESTquot;);--('Raw
Data'!V2:V60000=quot;Yquot;);'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....Hi Louise,

Your formula looks correct. I think that if you change the:
Raw Data'!S1:S60000
to
Raw Data'!S2:S60000
So that the array will match it might work.

Regards,
BondiTry

=SUMPRODUCT(--('Raw Data'!F2:F60000=quot;TESTquot;),--('Raw
Data'!V2:V60000=quot;Yquot;),('Raw Data'!S1:S60000))quot;Louisequot; wrote:

gt; I am trying to use SUMIf with 2 conditions, I see someone else asked this
gt; question before but I still can't get it to return anything other than #Value!
gt;
gt; Can anyone help me?
gt;
gt; =SUMPRODUCT(--('Raw Data'!F2:F60000=quot;TESTquot;);--('Raw
gt; Data'!V2:V60000=quot;Yquot;);'Raw Data'!S1:S60000)
gt;
gt; Column F and V contain text values and column S contains numerica values.
gt; does this make a difference?
gt;
gt; Thanks in advance....
gt;

Bondi is correct. In order to use SUMPRODUCT, each array must have
exactly the same number of members. In your case, the first two arrays
have 59,999 members and the third 60,000. Note that the don't have to
be the same rows, just the same size. Also, I've not used semi-colons
in my Sumproduct formulas. If you are still having problems try a
comma.

- John MichlHi John,

The semi-colons are the argument seperator in (at least) some Eurpean
countries.Changable in the regional settings i think.

Regards,
BondiThank you John and Bondi - it works perfectly now!

quot;John Michlquot; wrote:

gt; Bondi is correct. In order to use SUMPRODUCT, each array must have
gt; exactly the same number of members. In your case, the first two arrays
gt; have 59,999 members and the third 60,000. Note that the don't have to
gt; be the same rows, just the same size. Also, I've not used semi-colons
gt; in my Sumproduct formulas. If you are still having problems try a
gt; comma.
gt;
gt; - John Michl
gt;
gt;

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 :-)
------------------------------*------------------------------*----------------
quot;Barb Reinhardtquot; gt; wrote in message
...
gt; Try
gt;
gt; =SUMPRODUCT(--('Raw Data'!F2:F60000=quot;TESTquot;),--('Raw
gt; Data'!V2:V60000=quot;Yquot;),('Raw Data'!S1:S60000))
gt;
gt;
gt; quot;Louisequot; wrote:
gt;
gt;gt; I am trying to use SUMIf with 2 conditions, I see someone else asked this
gt;gt; question before but I still can't get it to return anything other than
gt;gt; #Value!
gt;gt;
gt;gt; Can anyone help me?
gt;gt;
gt;gt; =SUMPRODUCT(--('Raw Data'!F2:F60000=quot;TESTquot;);--('Raw
gt;gt; Data'!V2:V60000=quot;Yquot;);'Raw Data'!S1:S60000)
gt;gt;
gt;gt; Column F and V contain text values and column S contains numerica values.
gt;gt; does this make a difference?
gt;gt;
gt;gt; Thanks in advance....
gt;gt;