<div>
See if this works. Not checked<br />
<br />
=sumproduct(prods*( yr=2011)*( (code &lt;&gt;32)+(code &lt;&gt;35)+(code &lt;&gt;36)))
</div>


See if this works. Not checked

=sumproduct(prods*( yr=2011)*( (code <>32)+(code <>35)+(code <>36)))

<div>
<div class="content wysiwyg-content">
Is there a way to use sumif to see if something is not equal <br />
<br />
ie<br />
<br />
sumifs (prods, yr,2011, code, ?????????)<br />
<br />
I would like to check if code is not equal &quot;32&quot;, &quot;35&quot;,&quot;36&quot;<br />
<br />
Is there a way to do this?
</div>
</div>


Is there a way to use sumif to see if something is not equal 

ie

sumifs (prods, yr,2011, code, ?????????)

I would like to check if code is not equal "32", "35","36"

Is there a way to do this?

Using sumif for not equal to - Excel

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