Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
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, Bondi |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
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.... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
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 Michl |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
Hi John,
The semi-colons are the argument seperator in (at least) some Eurpean countries.Changable in the regional settings i think. Regards, Bondi |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
Thank you John and Bondi - it works perfectly now! :)
"John Michl" wrote: 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 Michl |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with 2 conditions
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
SUMIF - 2 conditions - with references | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Discussion (Misc queries) | |||
sumif with two conditions | Excel Worksheet Functions | |||
SUMIF based on 2 conditions | Excel Worksheet Functions |