SUMIFS (not blank, and othe conditions)
<p>I am trying to use <a href="https://support.office.com/en-us/article/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b" rel="nofollow noreferrer">SUMIFS</a> to sum a couple of conditions. I want my sum range to be <strong><em>column A</em></strong> and my first criteria range is <strong><em>column B</em></strong>, the criteria is that <strong><em>column B</em></strong> has something in it or essentially it isn't blank/0. The next criteria is if <strong><em>column C</em></strong> matches the year which is simple and I can get that to work, but my problem arises from the criteria of the first test. I have tried:</p>

<ol>
<li><code>SUMIFS(column A, column B, column B &gt; 0, column C, "16")</code></li>
<li><code>SUMIFS(column A, column B, column B &lt;&gt; 0, column C, "16")</code></li>
<li><code>SUM(SUMIFS(column A, column B, "1", column C, "16"), SUMIFS(column A, column B, "2", column C, "16"), SUMIFS(column A, column B, "3", column C, "16")</code>...</li>
</ol>

<p>Obviously, I do not want to use option 3 but it did seem to give me the right result. If I knew that the number in column B would be always under 5 then I may use this but as of now, I have to assume the number in column B can be from 0-1000. Is there something I am missing here? <br> All I want to do is sum up <strong><em>column A</em></strong> if <strong><em>column B</em></strong> is not blank or 0. Thanks. </p>