I need to create a COUNTIF formula that counts the cells where the dollar
value in the cells is greater than $8 but less then $10? Is this a multiple
criteria situation?

Pat

one way:

=SUMPRODUCT(--(A2:A438)*--(A2:A43<10))

Regards

Trevor


"Pat Walsh" <Pat wrote in message
...
I need to create a COUNTIF formula that counts the cells where the dollar
value in the cells is greater than $8 but less then $10? Is this a
multiple
criteria situation?

What does the -- (double hyphen) mean? I have seen it several times in
this NG but can not find a reference to it in Help.

Thanks,

Dennis

See http://www.mcgimpsey.com/excel/doubleneg.html

In article .com,
"den4673" wrote:

What does the -- (double hyphen) mean? I have seen it several times in
this NG but can not find a reference to it in Help.

Thanks,

Dennis

Thank you,

I found your website and related links very useful.

Dennis

Thank you,

I found your website and related links very useful.

Dennis