| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make formula look at diff sheet
I have this formula that works great if the data is on the same
sheet......=SUM(INDIRECT(ADDRESS(2,MATCH(A1,B1:M1, 0)+1)&":"&ADDRESS (2,MATCH(A2,B1:M1,0)+1))) I changed it to this on sheet2......=SUM(INDIRECT(ADDRESS(3,MATCH($C $9,Sheet1!B1:M1,0)+1)&":"&ADDRESS(3,MATCH($C$10,Sh eet1!B1:M1,0)+1))) And it returns the 2nd row on the sheet the formula is on rather than Sheet1. Any help would be appreciated. Not exactly sure how this bulletin board works. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Diff page margins in the same sheet | Setting up and Configuration of Excel | |||
| plotting column chart whch colors the bars diff for diff comm | Charts and Charting in Excel | |||
| SUMIF formula required to search for 2 diff values in 2 diff colum | Excel Worksheet Functions | |||
| how you make links between diff. cells on diff. work sheets | Excel Worksheet Functions | |||
| Linking 2 diff worksheets to a 3rd sheet | Excel Worksheet Functions | |||
Threaded Mode
