Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variable across all worksheets? | Excel Worksheet Functions | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions | |||
Can I use a variable to call up another sheet in Excel? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |