one way:

=IF(SUMPRODUCT(--(A1:A100=8000),--(A1:A100<=9999))0,"Warning","")


For an explanation of the "--" see

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


In article ,
Pat Z. wrote:

Can I add a question to this post?
How would you count if you are looking at a range of numbers, i.e. =8000
and <=9999?