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
  • 40,065
  • 18
  • 82
  • 114
aateeque
  • 2,111
  • 5
  • 23
  • 34

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
  • 160,885
  • 21
  • 326
  • 309