Countifs using a range name reference or Table references

[Mountlodge]

Hi,

The first Countifs using the Abs address works. The countifs using the Table header and column name doesnt. I would like to use the latter as I know more info will be appended monthly. I could make the abs address' $AT:$AT, $AU:$AU but my understanding of Tables is to remove the need for cell referencing. Where am I going wrong please?

=COUNTIFS(All_Data!$AT$3:$AT$9096,Tables!$N4,All_Data!$AU$3:$AU$9096,""). Note: I've checked the source data and Col AT (Account) are 4 or 5 numeric or alpha numeric. The first column in my return range is a Sort(Unique(Account))

=COUNTIFS(Tbl_Payments[[#Headers],[Account]],Tables!N5,Tbl_Payments[[#Headers],[Status]],"")

As always, the expertise here is greatly appreciated.
Thanks
JB

 

[Fluff]

Try it like

=COUNTIFS(Tbl_Payments[Account],Tables!N5,Tbl_Payments[Status],"")