summing daily data by month
 

I have this simplified data structure on worksheet1:
A B C
date red blue
01/01/2006 300 100
01/02/2006 200 200
..
01/31/2006 300 300
02/01/2006 100 100
..
02/28/2006 400 200

On worksheet2
A B C D
Item 01/06 02/06 03/06

red ???? ??? ??
blue ???? ??? ??

I am looking to sum all of red by month/year and all of blue by month/year.

Thanks!!

summing daily data by month
 

Try this:

Enter this formula in Sheet2 B2:

=SUMPRODUCT(--(TEXT(Sheet1!$A$2:$A$20,"mmmyyyy")=TEXT(B$1,"mmmyy yy")),INDEX(Sheet1!$B$2:$C$20,,MATCH($A2,Sheet1!$B $1:$C$1,0)))

Copy across then down as needed

Biff

"Mona" wrote in message
...
I have this simplified data structure on worksheet1:
A B C
date red blue
01/01/2006 300 100
01/02/2006 200 200
..
01/31/2006 300 300
02/01/2006 100 100
..
02/28/2006 400 200

On worksheet2
A B C D
Item 01/06 02/06 03/06

red ???? ??? ??
blue ???? ??? ??

I am looking to sum all of red by month/year and all of blue by
month/year.

Thanks!!