PDA

View Full Version : filtered data and named range



LOSS1574
09-09-2008, 08:15 AM
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?

xld
09-09-2008, 09:08 AM
Yes, post a workbook and tell us which ranges etc., it might make it clearer.

LOSS1574
09-09-2008, 10:44 AM
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
09-11-2008, 12:05 PM
Can someone please push me in the right direction.

Thank you.