Count
 

I want to count the number of cells in a column with 1-5 in them. The other
cells in this same column are "false" and I don't want those to be counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of these
works.

Please help.

Count
 

=COUNTIF(P1:P20,"1") etc.

Dave
--
Brevity is the soul of wit.


"Daren" wrote:

I want to count the number of cells in a column with 1-5 in them. The other
cells in this same column are "false" and I don't want those to be counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of these
works.

Please help.

Count
 

In what sense does =COUNT(P1:P200) not work?
This function counts the number of cells with numeric values
Did you really want SUM not COUNT?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Daren" wrote in message
...
I want to count the number of cells in a column with 1-5 in them. The
other
cells in this same column are "false" and I don't want those to be
counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of
these
works.

Please help.

Count
 

The "1-5" signifies a range, i.e. 1- 5 minutes. It's not being picked up
either by SUM or COUNT, possibly b/c it has logical IF statements in the
cells. Not sure if that makes an impact though.

"Bernard Liengme" wrote:

In what sense does =COUNT(P1:P200) not work?
This function counts the number of cells with numeric values
Did you really want SUM not COUNT?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Daren" wrote in message
...
I want to count the number of cells in a column with 1-5 in them. The
other
cells in this same column are "false" and I don't want those to be
counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of
these
works.

Please help.

Count
 

Thanks, Dave, that worked!!

"Dave F" wrote:

=COUNTIF(P1:P20,"1") etc.

Dave
--
Brevity is the soul of wit.


"Daren" wrote:

I want to count the number of cells in a column with 1-5 in them. The other
cells in this same column are "false" and I don't want those to be counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of these
works.

Please help.

Count
 

no problem.
--
Brevity is the soul of wit.


"Daren" wrote:

Thanks, Dave, that worked!!

"Dave F" wrote:

=COUNTIF(P1:P20,"1") etc.

Dave
--
Brevity is the soul of wit.


"Daren" wrote:

I want to count the number of cells in a column with 1-5 in them. The other
cells in this same column are "false" and I don't want those to be counted.
I've tried =count(p1:p20) and =countif(p1:p20,"false"), but neither of these
works.

Please help.