Sorting of References for Formulas
I want to use a formula in a cell (fixed), that contains a cell as reference
which in turn is subject to "move" by sorting. The column containing the formula in lets say A1, HAS do be moved (sorted), but the formula in cell Q8 (fixed there) should always refer to the value that was formerly in cell A1 and might now be in A5. This row 1 is part of a table that gets sorted. The line, that contains the value (in row 1) to be used in cell Q8 contains some fixed text, that never changes. Might this help? (Maybe something similar as "COUNTIF") Any suggestions? |
Sorting of References for Formulas
You can use the SUMIF formula if the value (e.g. a name) in reference to your
moving cell in your table is always the same (e.g. same line). The formula in Q5 would look like =SUMIF(B1:B20,"UNIQUE_VALUE",A1:A20) The name in column B must be UNIQUE, otherwise all the values with the same name are added. The WHOLE table should be sorted, of course. "fak119" wrote: I want to use a formula in a cell (fixed), that contains a cell as reference which in turn is subject to "move" by sorting. The column containing the formula in lets say A1, HAS do be moved (sorted), but the formula in cell Q8 (fixed there) should always refer to the value that was formerly in cell A1 and might now be in A5. This row 1 is part of a table that gets sorted. The line, that contains the value (in row 1) to be used in cell Q8 contains some fixed text, that never changes. Might this help? (Maybe something similar as "COUNTIF") Any suggestions? |
All times are GMT +1. The time now is 03:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com