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?


"Max" wrote:

do you know if there is a way i can replace
Adam1 Chicago wrote:
the "6" below with a cell reference?
=if(countif(a1:a100,"X64"),"Warning","")

To point to cell references, use in this way:
=IF(COUNTIF(A1:A100,""&X64),"Warning","")
where X64 contains the number

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----