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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Mestrella31" schrieb im Newsbeitrag
...
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

On Tue, 21 Dec 2004 10:43:06 -0800, "Mestrella31" wrote:

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