HI

This is possibly fairly simple but I just cannot see what it is I need.

In this formula

=SUMPRODUCT(--(D7:N7 <5.1),--(D7:N7>0))

I want the D7:N7 to be >&= to 0. What I also want to make sure is that it doesn't pick up blanks!


Any ideas?


Thanks so much

Saz