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