You must be using 2003. SUMPRODUCT should work with a defined range...Try
with D1:D1000

=SUMPRODUCT(--(D1:D10030000),--(D1:D100<75000))

Refer this link for --
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi Jacob

Thanks for this.

The SUMPRODUCT formula doesn seem to be working as it stands. What do the 2
hyphens represent~?

"Jacob Skaria" wrote:

Either use
=COUNTIF(D:D,"30000")-COUNTIF(D:D,"75000")

OR
=SUMPRODUCT(--(D1:D100030000),--(D1:D1000<75000))

With another condition
=SUMPRODUCT(--(C1:C1000="Y"),--(D1:D100030000),--(D1:D1000<75000))

=SUMPRODUCT(--(C1:C1000="N"),--(D1:D100030000),--(D1:D1000<75000))



--
If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

HI

I WOULD LIKE TO COUNT VALUES BETWEEN A RANGE. THE FORMULA I HAVE TRIED TO
USE IS: COUNTIF(D:D,"30000AND<75000") TO GET THE NUMBER OF VALUES BETWEEN 30
AND 75, HOWEVER, THIS DOES NOT WORK. CAN SOMEONE HELP?

ALSO, ON TOP OF THIS I WOULD LIKE TO COUNT A STATEMENT IN ANOTHER COLUMN
WHICH SAYS YES OR NO. SO THAT FROM THE VALUES BETWEEN 30 AND 75 I WOULD LIKE
TO KNOW WHICH ONES ARE ALSO YES AND NO. ANYONE WHO CAN HELP ME MUCH
APPRECIATED