Absolute reference with Table Nomenclature.

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

Please Login or Register  to view this content.

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

Try:

Formula:

Please Login or Register  to view this content.

Regards, TMS

E:E is NOT an absolute reference. If you drag that across, it will become F, G, H, etc

You're welcome.

Originally Posted by JO505

=ROUND(IFERROR(SUMIF(DailyFoodLogTBL[Date],$Z3,DailyFoodLogTBL[Protein]),""),0)

Also you would be better off with the IFERROR function outside the ROUND function - as it stands that formula can never return a blank "", because if the SUMIF formula returns an error then IFERROR will return "" and that value will cause ROUND to produce a #VALUE! error. You need it to be like this:

=IFERROR(ROUND(SUMIF(DailyFoodLogTBL[Date],$Z3,DailyFoodLogTBL[Protein]),0),"")