| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel transpose and references to cells in other sheets
Hi, I'm trying to transpose a spreadsheet table (Paste Special/
Transpose). The local formula (=SUM(B1:B2)) transpose fine, but the formulae that link to other sheets don't: =SUMIF('Sheet A'!C:C,B5,'Sheet A'!O:O) becomes =SUMIF('Sheet A'!#REF!,C90,'Sheet A'!#REF!) - effectively not keeping the references to the other sheet (Sheet A). What I want is the formula to keep the same place in the other sheet, ie: =SUMIF('Sheet A'!C:C!,C90,'Sheet A'!O:O) Anyone know how I can make this happen? As it's this sheet I'm transposing, not the other one. Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose cell references | Excel Discussion (Misc queries) | |||
| Does anyone have any good references for making excel sheets into webpages? | Excel Discussion (Misc queries) | |||
| Excel references to other sheets | Excel Worksheet Functions | |||
| Transpose Reletive Cell References? | Excel Worksheet Functions | |||
| Transpose-relative cell references would be useful. | Excel Worksheet Functions | |||
Threaded Mode
