excel-xp-training - Countif function

I'd go about it a different way.

in a column you won't be using, e.g. column CC, type = if(AND(A1>5,A1<10),1,0)

Then you can do a sum of that column.

If you have a range that won't be the same, try this: (Untested)

=if(isna(and(A1>5,A1<10),1,0),"",and(A1>5,A1<10),1,0)


this will return a blank instead of #N/A, allowing you to write your sum formula as =sum(C:C) rather than having to change the formula to it being the last cell in column C with data in.

Hope I am making sense?

Paul