I have a worksheet that uses macros to pull data from other sheets within the
workbook. One of the macros deletes any rows with a zero value after the data
is pulled in - the number of rows varies each time. I need to subtotal and
then total the $$ amount from three sections after the macros have run. The
sum formulas that I have on the sheet get messed up each time. How do I
resolve this?

Thanks!