SUMPRODUCT Problem
Can Someone tell me what is wrong with this formula.
I want to Sum All "B" products that fall betwene the acctounts
01010001-3907000 & 01010001-3907000 that is why I am trying
="01010001-3907*"
=SUMPRODUCT((Actual!$D$2:$D$10000="B")*(Actual!$F$ 2:$F$10000="01010001-3907*")*(Actual!$I$2:$I$10000))
For some reason the total i am coming up with is the total for "B" only
|