Hello friends! Unfortunately I am not permitted to upload the sample spreadsheet so I'll describe it.
I am practicing with a formula from a test table with Qtr1-Qtr4 on top and NE,SE,NW,SW on the left, Totals at the far right and bottom with sample numbers in the cells.
I have saved the Names in Name Manager so I can use =SUM(NW) and SUM(Qtr2) for example to list the Totals of those rows and columns.
My question is: How can I write a formula to address individual cells?
I want to subtract C2(Qtr2@NE) from D2(Qtr3@NE).
I would think
would work, but not the case.
I don't want to have to use
because I'm trying to learn to use the NAMES.
Any help will be appreciated. Thanks!
I am practicing with a formula from a test table with Qtr1-Qtr4 on top and NE,SE,NW,SW on the left, Totals at the far right and bottom with sample numbers in the cells.
I have saved the Names in Name Manager so I can use =SUM(NW) and SUM(Qtr2) for example to list the Totals of those rows and columns.
My question is: How can I write a formula to address individual cells?
I want to subtract C2(Qtr2@NE) from D2(Qtr3@NE).
I would think
Code:
=SUM(Sheet1!NE[Qtr2] - Sheet1!NE[Qtr3])I don't want to have to use
Code:
=C2-D2Any help will be appreciated. Thanks!
