Results 1 to 7 of 7

Absolute reference with Table Nomenclature.

Threaded View

JO505 Absolute reference with Table... 03-28-2015, 06:56 PM
TMS Re: Absolute reference with... 03-28-2015, 07:23 PM
TMS Re: Absolute reference with... 03-28-2015, 07:25 PM
JO505 Re: Absolute reference with... 03-28-2015, 07:44 PM
TMS Re: Absolute reference with... 03-28-2015, 07:48 PM
daddylonglegs Re: Absolute reference with... 03-28-2015, 08:11 PM
JO505 Re: Absolute reference with... 03-29-2015, 06:51 PM
  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Absolute reference with Table Nomenclature.

    I am having some issues keeping absolute references when dragging formulas across columns.

    =ROUND(IFERROR(SUMIF(DailyFoodLogTBL[Date],$Z3,DailyFoodLogTBL[Protein]),""),0)
    I want to keep the "[Date]" reference in the table as an absolute without resorting to a column reference such as "E:E"

    Jim O
    Last edited by JO505; 03-28-2015 at 07:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I use an absolute reference in a formula when referring to a table
    By quantumag in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2014, 02:01 PM
  2. [SOLVED] Absolute Cell reference in a Table
    By Glenn Kennedy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2014, 02:24 PM
  3. Absolute reference on named table
    By one11 in forum Excel General
    Replies: 2
    Last Post: 10-18-2011, 02:15 PM
  4. Absolute reference to table column in formula
    By jscott15 in forum Excel General
    Replies: 1
    Last Post: 11-03-2010, 01:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1