<div>
You could use a formula like the following to return the number or 0 if it's not a number:<br />

<pre><code id="code-20-40595729-1">if(isnumber(yourcell),yourcell,0)</code></pre>
</div>


You could use a formula like the following to return the number or 0 if it's not a number:


if(isnumber(yourcell),yourcell,0)

<div>
Excellent, thanks go me the data I needed
</div>


Excellent, thanks go me the data I needed

<div>
<div class="content wysiwyg-content">
I have the following formula that works fine:<br />
=SUMIFS(Report!H:H,Report!<wbr />L:L,&quot;Civil<wbr />ian&quot;,Repor<wbr />t!N:N,&quot;04*<wbr />&quot;)+SUMIFS(<wbr />Report!H:H<wbr />,Report!L:<wbr />L,&quot;Civilia<wbr />n&quot;,Report!<wbr />N:N,&quot;05*&quot;)<wbr /><br />
<br />
But a new wrinkle popped in, I can't add values that have the word Commit in column D. &nbsp;How would that impact the formula above?<br />
<br />
Thanks
</div>
</div>


I have the following formula that works fine:
=SUMIFS(Report!H:H,Report!L:L,"Civilian",Report!N:N,"04*")+SUMIFS(Report!H:H,Report!L:L,"Civilian",Report!N:N,"05*")

But a new wrinkle popped in, I can't add values that have the word Commit in column D.  How would that impact the formula above?

Thanks

excel formula need to add a NOT equal value

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