equal to and greater than

**Saz** · 08-30-2006, 05:00 AM

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

**oldchippy** · 08-30-2006, 05:15 AM

Originally Posted by Saz

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

Hi Saz,

How about using this formula

=COUNTIF(D7:N7,">=0")-COUNTIF(D7:N7,">5.1")

Does this sort your problem?

oldchippy

**Saz** · 08-30-2006, 05:31 AM

Sorry no it still doesn't pick up the 0's

Any more thoughts?

**oldchippy** · 08-30-2006, 06:02 AM

Originally Posted by Saz

Sorry no it still doesn't pick up the 0's

Any more thoughts?

Are you sure, because mine does, this includes 0's but not blanks, try copying and pasting my formula into your spreadsheet

oldchippy

**Saz** · 08-30-2006, 06:13 AM

Now when I first got your reply I did copy and paste your formula in hence my response.
But!!! As you replied again, as suggested, I thought I would try again and what'll you know .... it does work!

Thank you thank you thank you!

You have just made my life easier today as I had 3 columns on the go just to come up with the same result!