Assumptions:

On sheet 'Weave'...

B3:F3 contains your dates

A4:A10 contains C/R, EIFS, etc.

B4:F10 contains your data

On your summary sheet...

B1 contains your date of interest, such as 9/3/05

A2:A5 contains C/R, EIFS, OEM, and Export

Formula:

On your summary sheet...

B2, copied down:

=SUMIF(Weave!$A$4:$A$10,$A2,INDEX(Weave!$B$4:$F$10 ,0,MATCH(B$1,Weave!$B$3
:$F$3,0)))

Note that if you continue to add the dates along the first row of your
summary sheet, the formula can be copied across to other columns giving
you a summary for each date.

Hope this helps!

In article ,
"CheeseHeadTransplant"
wrote:

I have a spreadsheet with 3 sheets of date. On all 3 column A is the same
and Row 3 is the same. Column A is labeled Weave_Market_MTD and Row 3 is
Weave_Date_MTD. I need to sum all like items in Column A for a Date I have
in Cell D7 of the summary page. Before changing this sheet Column A did not
have two cells the same so I used the formula

=INDEX(Weave!$1:$65536,MATCH($A15,Weave!A:$A,0),MA TCH($D$7,Weave!$3:$3,0))

Now I have to add all the items for the same Market. This is what my sheet
looks like now:
09/01/05 09/02/05 09/03/05 09/04/05
09/05/05
C/R 5 10 15
20 25
EIFS 5 10 15
20 25
Export 5 10 15
20 25
OEM 5 10 15
20 25
Export 5 10 15
20 25
Export 5 10 15
20 25
OEM 5 10 15
20 25

If I need the total for 09/03/05 I need C/R = 15, EIFS = 15, OEM = 30 and
Export = 45.