ExcelBanter - COUNTIF

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNTIF (https://www.excelbanter.com/excel-discussion-misc-queries/213042-countif.html)

Barry Lennox

COUNTIF

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

Sheeloo[_3_]

COUNTIF

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

"Barry Lennox" wrote:

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

Barry Lennox[_2_]

COUNTIF

Thanks

I did find the other entries.

"Sheeloo" wrote:

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

"Barry Lennox" wrote:

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

All times are GMT +1. The time now is 09:32 PM.