I use SUMIFS function on my Mac Numbers. I wrote about this function in How to calculate summary with a condition on Numbers of Mac? - Shammerism, but I faced with the case SUMIFS doesn't calc if the range is not in the same sheet.
SUMIFS requires the calc range as below, quoted from How to calculate summary with a condition on Numbers of Mac? - Shammerism.
=SUMIFS(SheetB :: C,SheetB :: D,"=20171210")
I understood that SUMIFS requires Sheet Name if range is in other sheet. So I define the SUMIFS with using Sheet Name. But, it is not correct.
I always create sheet if I want to add a new table, so my Numbers file has sheets which has only 1 table. I am used to this style, like Microsoft Excel.
But, Numbers is different from Excel, sheet name and table name are different. SUMIFS requires Table Name instead of Sheet Name. The syntax of it should be below.
=SUMIFS(TableB :: C,TableB :: D,"=20171210")