<div>
Actually the criteria &quot;&gt;&lt;&quot;&nbsp;indicates not null
</div>


Actually the criteria "><" indicates not null

<div>
<div class="content wysiwyg-content">
I came across a SUMIF where it used &quot;&gt;&lt;&quot;&nbsp;as the criteria.. Can you translate ?<br />
<br />
=SUMIF(A1:A13,<b>&quot;&gt;&lt;&quot;</b>,B1:B13)
</div>
</div>


I came across a SUMIF where it used "><" as the criteria.. Can you translate ?

=SUMIF(A1:A13,"><",B1:B13)

SUMIF - Criteria of &quot;&gt;&lt;&quot;

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

SUMIF - Criteria of &quot;&gt;&lt;&quot;

SUMIF - Criteria of "><"