Google doesn't understand <> so that failed thus asking here. What does '<>' (less than followed by greater than) mean in Excel? For example: <pre class="prettyprint"><code>=SUMPRODUCT((E37:N37>0)*(E37:N37<>"")*(E37:N37)) </code></pre> What's happening here?

It means "not equal to" (as in, the values in cells E37-N37 are not equal to <code>""</code>, or in other words, they are not empty.)

What does <> mean in excel? [duplicate]

Google doesn't understand <> so that failed thus asking here.

What does '<>' (less than followed by greater than) mean in Excel? For example:

=SUMPRODUCT((E37:N37>0)*(E37:N37<>"")*(E37:N37))

What's happening here?

201

asked Jul 09 '11 13:07

It means "not equal to" (as in, the values in cells E37-N37 are not equal to "", or in other words, they are not empty.)

154

answered Sep 24 '22 21:09

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!