In column A you should type exact:
1.1.05
1.2.05
1.2.05
1.2.05
1.2.05
1.3.05
1.3.05

In column B you should type exact:
Y
N
...

1- Select cell C1,
2- you go to function to select sumproduct function,
3- "Function Aguments" will appear
4- then you type exactly --(A1:A30=DateValue("1.1.05") in agument1 and
so on.

It will work.
Note: it doesn't work when you just copy the formular and put to cell
C1. I don't know why.

It is for today and Good luck!
Rock

=sumproduct(--(A1:A30=DateValue("1.1.05")),--(B1:B30="Y"))


Not to sound dumb but are the -- spaces?

"Rock" wrote:


The formula of sumproduct worked well!

Try to look at your date fomat Michelle to have exact value in
between
quotation:

=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))

Regards
Rock


--
Rock
------------------------------------------------------------------------
Rock's Profile: http://www.excelforum.com/member.php...o&userid=29723
View this thread: http://www.excelforum.com/showthread...hreadid=494582