filtered data and named range

How can I add data to an existing subtotal filtered total in a cell from another worksheet by criteria? I have another sheet with additional premiums that I want to include in the premium based on the value of column A.

I’ve tried using name ranges but they are not working properly because of the filter. Any suggestions?

Yes, post a workbook and tell us which ranges etc., it might make it clearer.

Thanks,

I've attached a workbook..I need the premium (column E) on sheet1 (data1) to also include the premium (column E) from sheet (data 2).

Please let me know if you have any questions.

Can someone please push me in the right direction.

Thank you.