Section page number and total page number

Charles_Kenyon Thanks for your answer! Maybe I am not understanding it correctly, but I still am not able to number the document in the two ways I want to.

I want to number the pages through the whole document from 1 to {numpages}

Additionally, I want to have the section page number and the {sectionpages} on each page as well.

I seem to be only able to use {pages} for one of the two, but not for both in a document.

An Example with a few pages.

1st Page belongs to Section 1, Numbering that would show is: Page 1,  Page 1 of 2 in Section 1

2nd Page belongs to Section 1, Numbering that would show is: Page 2,  Page 2 of 2 in Section 1

3rd Page belongs to Section 2, Numbering that would show is: Page 3, Page 1 of 1 in Section 2

4th Page belongs to Section 3, Numbering that would show is: Page 4, Page 1 of 3 in Section 3

5th Page belongs to Section 3, Numbering that would show is: Page 5, Page 1 of 3 in Section 3

6th Page belongs to Section 3, Numbering that would show is: Page 6, Page 1 of 3 in Section 3