Sumproduct Formula

[Biz]

Hi,

I have sumproduct formula that works see below

=SUMPRODUCT(ISNUMBER(MATCH('Latest Pvt'!$A$5:$A$34,$AB$3:$AB$7,0))*('Latest Pvt'!$B$4:$M$4=$F$6)*('Latest Pvt'!$B$5:$M$34))

Just tried using -- but formula fails. How can I make it work with --.

Biz

 

[Dan Waterloo]

Since it already works, why do you want to change it?

In order to figure out what's wrong, please include the version of the formula that doesn't work.

 

[T. Valko]

Hi,

I have sumproduct formula that works see below

=SUMPRODUCT(ISNUMBER(MATCH('Latest Pvt'!$A$5:$A$34,$AB$3:$AB$7,0))*('Latest Pvt'!$B$4:$M$4=$F$6)*('Latest Pvt'!$B$5:$M$34))

Just tried using -- but formula fails. How can I make it work with --.

Biz

In some applications the double unary won't work due to the size and shape of the ranges involved.

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[Biz]

Since it already works, why do you want to change it?

In order to figure out what's wrong, please include the version of the formula that doesn't work.

Using Excel 2003 and I have heard double unary (--) is faster.

Biz

 

[Biz]

In some applications the double unary won't work due to the size and shape of the ranges involved.

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html

Thanks Biff for da link

Biz

 

[T. Valko]

Thanks Biff for da link

Biz

You're welcome!

Lots of good info there.