Title page should be counted/increment but must not display page numbering on title?

Question

I'm facing an interesting question about the numbering and counting of the pages. Here is how my article should look like in terms of page numberging :

Title page : count for page 1, but not numbered Abstract and so on : count for page 2+, numbered in roman II, III, etc, Main part : count start again on page 1, numbered in arabic 1, 2, 3, etc

So my MWE is working fine, it uses the titlepage environment to create a custom title. The pagenumbering commands are fine for switching the type of numerbing.

This difficult part was to actually make the titlepage count as a "page 1". I manage to do this by artificially incrementing the counter on page.

My questions :

• Does the pagenumbering always reset the page count ?
• Is the incrementation of the counter (relatively) safe to do ?
• Isn't there a cleaner was to achieve the same results ?

Here is my MWE code :

\documentclass[12pt,a4paper]{article}

\usepackage[utf8]{inputenc}
\usepackage{lipsum}

\newcommand{\CustomTitle}{%
    \begin{titlepage} % Start of page
    \Huge{A Title}
    \end{titlepage}
}

\begin{document}
% title
\CustomTitle%
% \addtocounter{page}{1} % <- artificially increment counter
\clearpage%
% Front matter
\pagenumbering{Roman}
\section*{a dummy abstract}
\lipsum[11]
\clearpage
\section*{a dummy executive summary}
\lipsum[4]
\clearpage
\section*{another dummy frontmatter}
\clearpage%
% Main
\pagenumbering{arabic}
\section{Introduction}
\lipsum[4-12]\clearpage

\section{Section 1}
\lipsum[13-23]\clearpage
\end{document}

Update 22/08/2019

Actually, there was a similar issue on Tex.SE. I'll go through the answers already provided

Answer 1

Yes,\pagenumbering resets the page counter.

Here is a modified version of \CustomTitle which does what you want, if I've well understood:

\documentclass[12pt,a4paper]{article}

\usepackage[utf8]{inputenc}
\usepackage{lipsum}

\newcommand{\CustomTitle}{%
    \begin{titlepage}%\thispagestyle{empty} % Start of page
    \Huge{A Title}
    \end{titlepage}
\stepcounter{page}
}

\begin{document}
\pagenumbering{Roman}
% title
\CustomTitle%

\section*{a dummy abstract}
\lipsum[11]
\clearpage
\section*{a dummy executive summary}
\lipsum[4]
\clearpage
\section*{another dummy frontmatter}
\clearpage%
% Main
\pagenumbering{arabic}
\section{Introduction}
\lipsum[4-12]\clearpage

\section{Section 1}
\lipsum[13-23]\clearpage

\end{document}