Creating an EXCEL COUNTIF formula for a range of values

[Pat Walsh]

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?

 

[Trevor Shuttleworth]

Pat

one way:

=SUMPRODUCT(--(A2:A43>8)*--(A2:A43<10))

Regards

Trevor

 

[den4673]

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

 

[JE McGimpsey]

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

 

[den4673]

Thank you,

I found your website and related links very useful.

Dennis

 

[den4673]

Thank you,

I found your website and related links very useful.

Dennis