<div>
I found the solution:<br />
<br />
First<br />
=COUNTIF(Numbers!$E$32:$E$<wbr />41,A4)<br />
was changed to:<br />
=COUNTIF(INDIRECT(&quot;Numbers<wbr />!$E&quot;&amp;(($A$<wbr />1-1)*($A$2<wbr />)+2)&amp;&quot;:$E&quot;<wbr />&amp;(($A$1)*(<wbr />$A$2)+1)),<wbr />A4)<br />
and<br />
=SUMIF(Numbers!$E$32:$E$41<wbr />,A4)<br />
was changed to<br />
=SUMIF(INDIRECT(&quot;Numbers!$<wbr />E&quot;&amp;(($A$1-<wbr />1)*($A$2)+<wbr />2)&amp;&quot;:$E&quot;&amp;(<wbr />($A$1)*($A<wbr />$2)+1)),A4<wbr />)<br />
<br />
Thanks, everyone that tried!
</div>


I found the solution:

First
=COUNTIF(Numbers!$E$32:$E$41,A4)
was changed to:
=COUNTIF(INDIRECT("Numbers!$E"&(($A$1-1)*($A$2)+2)&":$E"&(($A$1)*($A$2)+1)),A4)
and
=SUMIF(Numbers!$E$32:$E$41,A4)
was changed to
=SUMIF(INDIRECT("Numbers!$E"&(($A$1-1)*($A$2)+2)&":$E"&(($A$1)*($A$2)+1)),A4)

Thanks, everyone that tried!

<div>
I've requested that this question be closed as follows:<br />
<br />
Accepted answer: 0 points for ParkiII's comment <a href="https://www.experts-exchange.com/questions/28571608/How-to-create-formulas-on-the-fly-in-Excel-2010.html?anchorAnswerId=40472243#a40472243" rel="ugc">#a40472243</a><br />
<br />
for the following reason:<br />
<br />
Thanks Andrew, see my comments.
</div>


I've requested that this question be closed as follows:

Accepted answer: 0 points for ParkiII's comment #a40472243 [https://www.experts-exchange.com/questions/28571608/How-to-create-formulas-on-the-fly-in-Excel-2010.html?anchorAnswerId=40472243#a40472243]

for the following reason:

Thanks Andrew, see my comments.

<div>
Please, give Andrew Hancock the points, <b>he earned them</b>! &nbsp;I just did not complete the form correctly, my bad. &nbsp;I gave him an 'A' thinking that would trigger him getting the 500 points.
</div>


Please, give Andrew Hancock the points, he earned them!  I just did not complete the form correctly, my bad.  I gave him an 'A' thinking that would trigger him getting the 500 points.

<div>
Andrew should have the points - see above.
</div>


Andrew should have the points - see above.

<div>
<div class="content wysiwyg-content">
I want to have the values &quot;<b>32</b>&quot; and &quot;<b>41</b>&quot; within the formula &quot;=COUNTIF(Numbers!$E$32:$E<wbr />$41,A4)&quot; calculated from the value of some cells, say A1 and A2.
</div>
</div>


I want to have the values "32" and "41" within the formula "=COUNTIF(Numbers!$E$32:$E$41,A4)" calculated from the value of some cells, say A1 and A2.

How to create formulas on the fly in Excel 2010

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Office Productivity refers both to the act of being productive and efficient in an office or professional environment, as well as the software applications used to "produce" information. This includes the development of professional skills, creating work processes, and almost any program used to create or modify a document, image, audio or video clip. However, business application suites such as Microsoft Office, which include word processing, spreadsheet and presentation programs, are typically called productivity software, as contrasted with a "utility program," such as a file manager, which is used to organize files and folders on the computer. Many office- and business-oriented groups of programs are organized into suites.