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?
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.)
精彩评论