Sumproduct by date

[WH99]

I have a data sheet that get entered with date and hours for the year.
Some days we might have several entries or just one, it depends on how much
work is done.
I have a table numbered 1 to 31(col A). They corespond to the days in a
month. What I need is a formula down col B (1 to 31 days) to sum the total
for each day for the selected month.

 

[Bob Phillips]

=sumproduct(--(YEAR(Sheet2!$A$2:$A$200)=2008),--(MONTH(Sheet2!$A$2:$A$200)=A2),Sheet2!$B$2:$B$200)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[WH99]

Thanks Bob,
No luck with your formula!
But I am playing with the following formula:
=IF(MONTH(A11)=MONTH(A10),B11+C10,B11)
(Col C being the total for that particular day).
Tried to change the MONTH to DATE or DAY but with no luck.
Any ideas?

 

[WH99]

Got it to work with:
=IF(DAY(A11)=DAY(A10),B11+C10,B11)
many thanks