The formula would beĭont worry too much about how to create formulas, the important part is the Sheet2!A1:A10. Don’t forget the exclamation mark after the worksheet name.įor example, let’s suppose that we are working on Sheet1 and we want to sum the values of cells A1 to A10 on Sheet2. The reference to this cell is simply Sheet2!E12. We are creating a formula in Sheet1 that uses data in cell E12 on Sheet2. Suppose that we are using two worksheets in the same workbook: Sheet1 and Sheet2. Let’s now look at references to cells on different worksheets. So far we have looked at cell references on the sme worksheet. ![]() The range goes from cell D2 to D4 so the range is denoted by D2:D4. What if we want to refer to a range of cells?
0 Comments
Leave a Reply. |