|
Posted to microsoft.public.excel.misc
|
|
|
find occurance of something from 2 creterion
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
http://xldynamic.com/source/xld.SUMPRODUCT.html
--
David Biddulph
"liu" wrote in message
...
BTW, what does "--" mean in the function?
Thanks for the help.
On Feb 5, 2:02 pm, liu wrote:
On Feb 5, 1:33 pm, "Bernard Liengme"
wrote:
In all Excel versions: =SUMPRODUCT(--(A1:A100="A"),--(B1:B100=2008))
Only in Excel 2007 : =SUMPRODUCT(--(A:A="A"),--(B:B=2008))
Only in Excel 2007: =COUNTIFS(A1:A100,"A",B1:B100,2008)
best wishes
That works. Thank you so much for the hlep.
|