Quote Originally Posted by JeteMc View Post
Formula: copy to clipboard 
=SUMIFS(tbl_Input[2016],tbl_Input[[Classification Serial]:[Classification Serial]],tbl_Output[@[Classification Serial]:[Classification Serial]])
This is working, but I am having a tough time trying to understand some of its parts so I can apply these techniques elsewhere because I am dealing with a lot of tables, and using the

@

:

[]

seems critical keys for several operations when building formulas for tables.

So back to the formula above, I followed it and started adding it manually to understand.

Please, let me divide the formula into its main sections:

2023-10-07 00 49 36.png
  • SUMIFS ... this is the formula string.
  • sum_range ... this is the 1st part of the formula that represents the range that needs to be summed, which is tbl_Input[2016].
  • ,Then we add the 1st separator which is the comma ... , .
  • criteria_range1Then we add the 2nd part of the formula sections which represent criteria_range1, which is tbl_Input[Classification Serial]. Now I am confused with the extra :[Classification Serial]] you added "line #7 in the above image, so what is the purpose of that addition?
  • @ Now you are adding the last part of the formula that contains @tbl_Output[@[Classification Serial]:[Classification Serial]], so now you are an extra @ before the name of the table!? (why? isn't it supposed to be like the previous part? and only be tbl_Output[Classification Serial] ?
  • Also why 2 extra @ ? one before the table name, and the 2nd before column name?
  • Also why column name repeated between the :

I hope you or other members clear these points for me in order to get a better understanding.