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.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Posting Permissions
Reply With Quote
