Calculate per page

Hi

Is it possible to calculate the amounts in a specific column per page automatically by including the formula or macro in a footer.

Thanks

I believe that if you select any range on a sheet the sum will show on the bottom of the Excel Screen. Did you mean footer as in printed page?

Hi

Yes. The idea is to add or change rows on any printed page and that each page then be calculated automatically. The content of the rows on the pages will not remain the same always.

Thanks