I am sure this is something that is simple, but I have not worked with Excel in many years. Could someone please tell me what the formula is that I use to give me a sub-total of all my totals that are on individual sheets. ex: I have sheet1-9 with sheet 3 deleted, each of these sheets in my workbook has a total of purchase prices in the E34 cell. How do I use one of the cells in an existing page to add up all of the totals in each sheet in cellE34 and give a subtotal?
Thank you abundantly!
Thank you abundantly!