Sheet1 contains an autofiltered table which includes a column headed "ID" formatted as text. and a column headed "AMOUNT" (number)
Named ranges Sheet1!ID and Sheet2!AMOUNT embrace the used areas
Sheet2 contains a table of two columns also headed ID (text) and AMOUNT (number)
Named ranges Sheet2!ID and Sheet2!AMOUNT embrace the used areas
In Sheet2, the values contained in column ID are unique.
In Sheet1, the values contained in column ID are not unique but each entry appears in column ID of Sheet 2.

(yeah, I know, this is beginning to sound like a problem better handled in Access).

I should like a formula (or approach) for calculating the total of all values contained in Sheet2!AMOUNT for those cases where the corresponding value in Sheet2!ID matches at least one instance of the filtered values displayed in Sheet1!ID

If it is any help, the values in Sheet1!AMOUNT are the same values as Sheet2!AMOUNT. However a simple SUBTOTAL(9,Sheet1!AMOUNT) does not work because of duplicated values in Sheet1!ID.

Thanks in advance.