You are summing on two criteria - date and type of response. Sumif only
handles a single condition. As long as this will me a manual operation each
day, you might try the pivot table as suggested. It is fast and easy.

--
Regards,
Tom Ogilvy

"Michelle" wrote in message
...
If I would change my Y & N to 1 and 0 could I do a sumif?
This seems like a lot of extra work as I need to do this for every day of
the year for both they Y and the N it would not be as bad if you could do
the
copy thing.

"Rock" wrote:


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