Start the function as usual and then click on the sheet and the range of cells-the same way you did in the previous examples. But you might want to write a function (such as SUM) that references a range of cells on another worksheet or workbook. Referencing a single cell is useful enough. How to Cross Reference a Cell Range in a Function Keeping data in one workbook, if possible, is more reliable. Users creating or renaming folders and moving files can break these references and cause errors. Although creating references to other workbooks is straightforward, they are more susceptible to issues.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |