Subtotal unique values in autofiltered field

[1eyedjack]

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.

[Claymation]

If I understand your question correctly you will probably be able to use SUMPRODUCT to get the desired result. However, I can't provide an exact formula or example as I don't know exactly what your data looks like. Can you post a copy or example of your data?