6

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?

Joey Adams
  • 41,996
  • 18
  • 86
  • 115
aateeque
  • 2,161
  • 5
  • 23
  • 35

1 Answers1

18

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.)

James Allardice
  • 164,175
  • 21
  • 332
  • 312