Pagewise Subtotal of Two Columns before each Page Break

What you ask is not possible, there is no formula / function that can identify the position of a page break.

I mean I want subtotal for every 25 rows and then page break. No need to identify page break

https://www.excelforum.com/excel-pro...each-page.html

A macro like above thread and instead of progressive total I need only page subtotal Sir

So where do you want the results?

The odd numbered pages don't have an empty row at the end to be used for the results!

Sir , I want current page setup not disturbed that is 24/25 rows (or say 12 rows which have datas and 12 empty rows in between) per page excluding page titles (4 rows).... And want subtotal at every 25th or 26th rows.

In Helper Column N

I put

=INT((ROW(A25)-1)/24)+1

in N5

and fill till the end. I subtotal at each change in N... But look at the page number 178 and 179 and also others in attached XL File... the datas pushed down from page top to middle or somewhere. It shouldn't happen.

Your INT formula is wrong, try this one in N5

=INT((ROWS(N$5:N5)-1)/25)+2

See if that fixes the problem.

No Sir... This also not fixes the problem

https://i.imgur.com/lsqdFVv.jpg

Attachment 634653

See page 171 contents comes down from first line in this screen shot

Your screen capture has 26 rows per page, the formula is based on the 25 rows per page in your original file.

If you change the file from 25 rows per page to 26, then you need to change the formula from 25 to 26 as well.