Page numbers in contents and footer

and use { SECTIONPAGES } to insert the total number of pages in a section.

What option are you choosing under Insert > Header & Footer > Page Number?

For all of the options except for "Page Margins" there are "Page X of Y" options - You may have to scroll down a bit to see them.

Or, if you want to create it manually, you can add the number of pages by using the NumPages Field Code.

Insert > Quick Parts > Field > NumPages

When editing the footer, choose page numbers -> format page numbers and then choose start from 1 in the lower part of the tab. The part of the doc you want to number has to be in a new section, but as I noticed you already did that.