<div>
Changed A to AA, worked like a charm. &nbsp;Thanks. <br />
=SUMPRODUCT(ISNUMBER($AA$6<wbr />:$AA$10000<wbr />0)+0,$Z$6:<wbr />$Z$100000)<wbr />
</div>


Changed A to AA, worked like a charm.  Thanks.
=SUMPRODUCT(ISNUMBER($AA$6:$AA$100000)+0,$Z$6:$Z$100000)

<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
I have the below formula where the ISNUMBER parameter is not working.<br />
=SUMIF($AA$6:$AA$10000, ISNUMBER($Z$6:$Z$100000),$<wbr />Z$6:$Z$100<wbr />000)<br />
<br />
Question: &nbsp;How to pull off a SUMIF where instead of testing the AA column for a specific string (&quot;cash&quot;, &quot;not paid&quot;), test it to see if the corresponding AA cell is numeric? &nbsp;(i.e. a check number)<br />
<br />
Thanks in advance.<br />
Jim
</div>
</div>


Hi all

I have the below formula where the ISNUMBER parameter is not working.
=SUMIF($AA$6:$AA$10000, ISNUMBER($Z$6:$Z$100000),$Z$6:$Z$100000)

Question:  How to pull off a SUMIF where instead of testing the AA column for a specific string ("cash", "not paid"), test it to see if the corresponding AA cell is numeric?  (i.e. a check number)

Thanks in advance.
Jim

How to do an is numeric within a SUMIF

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