Hello:

I have a sheet like this:

A B C D E F
G H I
1 2009 2009 2009 2010 2010 2010
2010 2011
2 11 11 12 1 1
2 3 3
3
4 Plastic 5 9 6 10 9
2 11 8
5 Metal 1 0 0 2 8
12 1 1
6 Wood 0 7 6 5 1
2 7 8

This sheet has a list in column A of many items and every column is the
total for that day. So column B has 5 plastic on November 2009. and Column C
had 9 plastic on november 2009. I want to use a formula to total how many
plastic were sold in november 2009. The problem is, that the above chart
grows everyday, with new columns every day, which formula can I use to look
up the whole row and total all amount for plastic for a particular month.

I have this formula which did it for a specific range, but I need it to look
in the whole row.

=SUMPRODUCT(--(Sheet1!$B$1:$F$1=2008),--(Sheet1!$B$2:$F$2=sheet1!D$4),(Sheet1!$C410:$I4))


Thanks for your help.

Art