structured formula

  1. P

    Structured Referencing of a portion of a colum

    What is the syntax to reference a table's column, not the whole column but the portion from row 1 to the current row? Let's say we are in the 5th row of a table, in column "MyColumn" Equivalent to 6th row and 2nd column (column B) in the spreadsheet Referencing the cell will be [@MyColumn]...
    • protrader
    • Thread
    • portion of column structured formula structured references
    • Replies: 1
    • Forum: Excel Questions
  2. S

    Structured reference problem using table

    I am using the table function and structured reference for a formula on the far right marked in yellow, "YTD Quota". That formula is: =SUM(Main[@[Jan]:[Mar]]), and sums Jan, Feb and Mar (also in yellow) in the row "Name 1". I would like the second sum term in the formula "Mar" to be variable...
  3. S

    Referencing a cell outside the table in a structured formula

    Hi, The following formula in cell T4 (see table below) sums rows in a table from Jan (January) up to Dec (December). However, I want to make the second sum term, Mar (March) in this case, variable, and refer to a value outside of the table. (I want to have the flexibility to change this from...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top