COUNTIF

B

Barry Lennox

I am having trouble with 'COUNTIF'. If I have the criteria as a single cell
reference all is well. If I enter ">" or "<" either alone or as a range I get
0 as the answer. I am wanting to count entries in a date range. The problem
is not one to do with dates as I tried it with plain numerals. I am running
Excel 2002 SP3 on Vista Home Premium
 
B

Barry Lennox

Thanks

I did find the other entries.

Sheeloo said:
This was answered elsewhere today...

Two choices
either use
=COUNTIF(A1:A100;B1)

with B1 having the condition like >10

or

=COUNTIF(A1:A100,">"&B1)
with B1 containing a value like 10
Click to expand...
 
Top