=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.
Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html
Barb Reinhardt wrote:
Thanks everyone. Can someone explain what the -- in the sumproduct formula
means?
"Bernard Liengme" wrote:
Try =SUMPRODUCT(--(AL3:AL84=date(2006,3,1)),--(AP3:AP84=6))
I am assuming you use US date convention
Confirm with simple ENTER
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Barb Reinhardt" wrote in message
...
What am I doing wrong he
=SUMPRODUCT(AL3:AL84="3/1/2006")*(AP3:AP84=6)
I want to count the number of times AL3:AL84 = 3/1/2006 AND AP3:AP84 = 6.
I keep getting ZERO when this is a non zero number. I have entered it
with
CTRL SHIFT ENTER (I think that's it) and it has {} around it.
Thanks,
Barb Reinhardt
--
Dave Peterson