Sumproduct by date
 

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.
--
WH99

Sumproduct by date
 

=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" wrote in message
...
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.
--
WH99

Sumproduct by date
 

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


"Bob Phillips" wrote:

=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" wrote in message
...
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.
--
WH99

Sumproduct by date
 

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


"WH99" wrote:

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


"Bob Phillips" wrote:

=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" wrote in message
...
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.
--
WH99