nested sumif
 

i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??

nested sumif
 

How about SUMPRODUCT?

=SUMPRODUCT(--($B$1:$B$50=B50),--($I$1:$I$150=TRUE),($F$1:$F$150))

Hope this helps.
--
John C


"Gluefoot" wrote:

i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??

nested sumif
 

Try
=SUMPRODUCT(--(B1:B50=B50),--(I1:I50=TRUE),(F1:F50))

"Gluefoot" wrote:

i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??

nested sumif
 

How about:
=SUMPRODUCT(--(B1:B50=B50),--I1:I50,F1:F50)

Bob Umlas
Excel MVP

"Sheeloo" wrote in message
...
Try
=SUMPRODUCT(--(B1:B50=B50),--(I1:I50=TRUE),(F1:F50))

"Gluefoot" wrote:

i need to combine 2 arguments in a SUMIF function so i can use it with
Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will
work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to
combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??

nested sumif
 

this worked great!. thanks a lot, i have 1 question though. what does the
"--" in front of the array do exactly?

"John C" wrote:

How about SUMPRODUCT?

=SUMPRODUCT(--($B$1:$B$50=B50),--($I$1:$I$150=TRUE),($F$1:$F$150))

Hope this helps.
--
John C


"Gluefoot" wrote:

i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??

nested sumif
 

It is 'double unary'. You can do a search on what that means :)
--
John C


"Gluefoot" wrote:

this worked great!. thanks a lot, i have 1 question though. what does the
"--" in front of the array do exactly?

"John C" wrote:

How about SUMPRODUCT?

=SUMPRODUCT(--($B$1:$B$50=B50),--($I$1:$I$150=TRUE),($F$1:$F$150))

Hope this helps.
--
John C


"Gluefoot" wrote:

i need to combine 2 arguments in a SUMIF function so i can use it with Excel
2003. i'm basically trying to make it so a SUMIFS script i wrote will work in
earlier versions of Excel. here are the 2 SUMIF arguments i need to combine...

SUMIF(B1:B50, B50, F1:F50)
SUMIF(I1:I50, TRUE, F1:F50)

so i need to add the cells in F1:F50 where their corresponding value in
I1:I50 is TRUE, and the corresponding value in B1:B50 = B50.

can someone help??