What are you doing up so late?

Is it a holiday in GB?<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
It's like the Chuckle Brothers <vbg

"RagDyer" wrote in message
...
OR, try entering this data:

RangeA
A2:A4 = Tom, Dick, Harry

RangeB
B1:D1 = 2006, 2007, 2008

Sum Range
B2:D4 = 1,2,3:4,5,6:7,8,9

And try this:
=SUMPRODUCT((A2:A4="Dick")*(B1:D1=2008)*B2:D4)
And you'll get 8.

But run:
=SUMPRODUCT(--(A2:A4="Dick"),--(B1:D1=2008),B2:D4)
And see what you'll get.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Bob Phillips" wrote in message
...
Yes there is. Just trying entering this data

A1:A10 (RangeA): Name,Bill,Bill,Bill,Joe,Joe,Joe,Mark,Jim,Jack
B1:B10 (RangeB): Year,2008,2009,2008,2007,2008,2009,2007,2007,2007
C1:C10 (SumRange): Amt,1,2,3,4,5,6,7,8,9

Run this formula,

=SUMPRODUCT(--(RangeA="Bill"),--(RangeB=2008),SumRange)

and you get 4 as you would expect. But try

=SUMPRODUCT((RangeA="Bill")*(RangeB=2008)*(SumRang e))

and see wat you get.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
No difference.

Google for:
"double unary minus" Excel sumproduct
--
David Biddulph

"QuietMan" wrote in message
...
What is the difference between these two formulas?
sumproduct((RangeA=CriteriaA)*(rangeB=CriteriaB)*( SumRange))

sumproduct(--(RangeA=CriteriaA),--(rangeB=CriteriaB),--(SumRange))

What exactly "--" represent?

Thanks


--
Helping Is always a good thing