SUMPRODUCT Problem

[Guest]

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

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((Actual!$D$2:$D$10000="B")*(LEFT(Actual!$F$2:$F$10000,13)="01010001-3907")*(Actual!$I$2:$I$10000))

 

[Ron Rosenfeld]

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

What is the range of accounts?

Your formula is not giving you what you wrote, rather it should be giving you
the total of all accounts with B products with an account range of:

01010001-3907000 & 01010001-3907nnnnnnn.... where n is any character.
--ron