View Single Post
  #1   Report Post  
Mestrella31
 
Posts: n/a
Default 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