filtered data and named range

[LOSS1574]

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?

[Bob Phillips]

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

[LOSS1574]

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.

[LOSS1574]

Can someone please push me in the right direction.

Thank you.