Not sure I really understand how the columns can increase but here goes:
1) why not expand the formula to include more rows and columns if they are
currently empty
=SUMPRODUCT(--(Sheet1!B1:Z1=2008)*(Sheet1!B2:Z2=D$4)*Sheet1!B4:Z 104)
Note you must use the * method rather than the double negation when the
arrays are of dissimilar size
2) if you have Excel 2007, you can use full row/column references as in
(Sheet!1:1=2008)

best wishes

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