Hello Nick:
If its just three cells try
=AND(X2=40,X2<=49)+AND(BX2=40,BX2<=49)+AND(CX2= 40,CX2<=49)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Nick Horn" <Nick wrote in message
...
Hi

Please can anyone help.

I need to count a group of cells that are spread through the spreadsheet
which meet a criteria range e.g

count the number of cells for X2, BX2, CX2 that are greater than or equal
to
40 but less than or equal to 49.

I cant seem to use COUNTIF. Presumably because it needs a range e.g.
X2:CX2
and I do not not want to count all cells in the range, just specific
cells.

Many thaks for any help.

Nick