<div>
Thanks Barry. &nbsp;I went in and formatted all the cells in column H as Text. &nbsp;I hope it works.<br />
<br />
Thanks so much for your help!
</div>


Thanks Barry.  I went in and formatted all the cells in column H as Text.  I hope it works.

Thanks so much for your help!

<div>
Wow, I could have never figured that out in a million years. &nbsp;Sure will. &nbsp;Thanks!
</div>


Wow, I could have never figured that out in a million years.  Sure will.  Thanks!

<div>
It seems to be working as far as I can tell Barry. &nbsp;Thanks so much!
</div>


It seems to be working as far as I can tell Barry.  Thanks so much!

<div>
If you're happy with the proposed solution(s) bifsniff then you should just accept one or more solutions rather than request closure.....<br />
reagrds, barry<br />

</div>


If you're happy with the proposed solution(s) bifsniff then you should just accept one or more solutions rather than request closure.....
reagrds, barry


<div>
<div class="content wysiwyg-content">
Hello. &nbsp;I'm using a SUMPRODUCT formula as follows: &nbsp;=SUMPRODUCT(('wisconsin 006 036 11-1-08 to 4-'!$H$9:$H$11=&quot;036&quot;)*('wi<wbr />sconsin 006 036 11-1-08 to 4-'!$I$9:$I$11&gt;=1)*('wisco<wbr />nsin 006 036 11-1-08 to 4-'!$I$9:$I$11&lt;=1499)*('wi<wbr />sconsin 006 036 11-1-08 to 4-'!$M$9:$M$11&gt;0)*('wiscon<wbr />sin 006 036 11-1-08 to 4-'!$N$9:$N$11&gt;0)).<br />
<br />
I put quotation marks around the 036 in $H$9:$H$11=&quot;036&quot; because if I don't put quotation marks around 036, &nbsp;Excel changes it to 36. &nbsp;Excel seems to be accepting it as a correct formula. &nbsp;Is this okay and will it work?<br />
<br />
Thank you!
</div>
</div>


Hello.  I'm using a SUMPRODUCT formula as follows:  =SUMPRODUCT(('wisconsin 006 036 11-1-08 to 4-'!$H$9:$H$11="036")*('wisconsin 006 036 11-1-08 to 4-'!$I$9:$I$11>=1)*('wisconsin 006 036 11-1-08 to 4-'!$I$9:$I$11<=1499)*('wisconsin 006 036 11-1-08 to 4-'!$M$9:$M$11>0)*('wisconsin 006 036 11-1-08 to 4-'!$N$9:$N$11>0)).

I put quotation marks around the 036 in $H$9:$H$11="036" because if I don't put quotation marks around 036,  Excel changes it to 36.  Excel seems to be accepting it as a correct formula.  Is this okay and will it work?

Thank you!

SUMPRODUCT FORMULA IN EXCEL

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

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.