SUMPRODUCT Problem

M

Mestrella31

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
 
F

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))
 
R

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
Click to expand...

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
 
Top