Hi,
Just out of interest more than anything but what is the signifcance of
the "--" that appears before each argument as opposed to "*", that
Excel Help puts between the two arguments?
Cheers,
Bernard Liengme Wrote:
I will assume the first column are dates
With dates in column A and colours in B
=SUMPRODUCT(--(A1:A5DATE(2006,5,1)),--(B1:B5="green"))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"mg" wrote in message
...
table:
1.5.2006 blue
2.5.2006 green
30.4.2005 green
21.5.2006 yellow
21.6.2006 blue
how can I count all the green guys with the datum after 1.5.2005?
countif will not probably work...
--
giantwolf
------------------------------------------------------------------------
giantwolf's Profile:
http://www.excelforum.com/member.php...o&userid=24718
View this thread:
http://www.excelforum.com/showthread...hreadid=383850