Syntax help - translating actual column/field names to test sample SumProduct returning wrong value

you should enclose sheet names in brackets (the whole thing not just the table data column name)
=Country_Billing[agtno] should be =[Country_Billing@agtno] (this from same workbook)
 
=testsample.xlsx!Table1[@agtno]    This from another book , notice filename is first THEN ! sign    then complete table reference

I see you are also missing some of the @ signs that identify table columns

what if the referencing of a table that is linked to another query.  The table is based on an query,  what is the proper syntax?

ok here is what I have so far and get error:

Problem seems to be with the +[@Column1] part in the formula.

Also qualify the cell references with Table Name e.g.  change [@agentno] to country_results[@agentno] and same with other cell references in the formula.

so How do I get the revised agt_amount?  for the first instances of the AgentNo only?

=IF(qryDifference[agentno]=Country_results[agentno],qryDifference[agentno],SUMPRODUCT((qryDifference[agentno]=Country_results[@agentno])*(qryDifference[Validate Adjustment]="Y")*qryDifference[New Adj Amt])+Country_results[agt_amt])

the new amount = First value per agentno plus the difference value on a different sheet within the same workbook. and if validataion is null then return the original value .

NOTE:  The references are what the system places when I click on the column to make sure I have it correct.

I will also need to modify the tot_leads amount where the validation = Y.

Did the formula you posted in your last post work for you?
As I said the problem would be with +Country_results[agt_amt] part.

it would return a result some times but not the correct value.

Found solution with help of another ee posting.

found the solution elsewhere on ee