SUMPRODUCT

[Brad E]

In a message from Frank Kabel to Arturo on Sep 3 2004 at
11:03 AM, Mr. Kabel replied with:

try:
=SUMPRODUCT((LEFT(A1:A100,1)="A")*(B1:B100="Y"),C1:C100)

why doesnt this
=SUMPRODUCT((LEFT(A1:A100,1)="A"),(B1:B100="Y"),C1:C100)
give the same result?

Every time I try SUMPRODUCT I use commas instead of *s and
I can't get mine to work.

Thanks, Brad E.

 

[Frank Kabel]

Hi
use:
=SUMPRODUCT(--(LEFT(A1:A100,1)="A"),--(B1:B100="Y"),C1:C100)

You have to coerce the boolean values to real numbers. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html