Determine number of rows meeting a condition
 

Within Office XP I need to count how many instances there are of a condition
being met...
For example, a column is assigned a categorizing code such as "A", "B", or
"C"... Is there a way to count the rows that have an "A" code assigned to
them? I'm looking for a solution specifying something like "25 rows meet the
"A" criterion".

Thank you...

Determine number of rows meeting a condition
 

I will assume Office XP refers to Excel 2003
Let's assume the column is D
If you want to sum all the A's in the entire column use
=COUNTIF(D:D,"A")
If you need to check only part of the column (rows 1 to 100, for example)
=COUNTIF(D1:D100,"A")

To make a fancy answer use
=COUNTIF(D:D,"A")&" rows meet the 'A' condition"
If you are a double-quotes person
=COUNTIF(D:D,"A")&" rows meet the ""A"" condition"
where there are two double-quotes each side of A

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Snapps" wrote in message
...
Within Office XP I need to count how many instances there are of a
condition
being met...
For example, a column is assigned a categorizing code such as "A", "B", or
"C"... Is there a way to count the rows that have an "A" code assigned to
them? I'm looking for a solution specifying something like "25 rows meet
the
"A" criterion".

Thank you...

Determine number of rows meeting a condition
 

=COUNTIF(A:A,"A") & " rows are coded A"


Gord Dibben MS Excel MVP


On Thu, 2 Nov 2006 11:58:02 -0800, Snapps
wrote:

Within Office XP I need to count how many instances there are of a condition
being met...
For example, a column is assigned a categorizing code such as "A", "B", or
"C"... Is there a way to count the rows that have an "A" code assigned to
them? I'm looking for a solution specifying something like "25 rows meet the
"A" criterion".

Thank you...

Determine number of rows meeting a condition
 

....My mistake, I'm using Excel 2002. Is there a method that you know of for
that version? Thanks again...

"Bernard Liengme" wrote:

I will assume Office XP refers to Excel 2003
Let's assume the column is D
If you want to sum all the A's in the entire column use
=COUNTIF(D:D,"A")
If you need to check only part of the column (rows 1 to 100, for example)
=COUNTIF(D1:D100,"A")

To make a fancy answer use
=COUNTIF(D:D,"A")&" rows meet the 'A' condition"
If you are a double-quotes person
=COUNTIF(D:D,"A")&" rows meet the ""A"" condition"
where there are two double-quotes each side of A

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Snapps" wrote in message
...
Within Office XP I need to count how many instances there are of a
condition
being met...
For example, a column is assigned a categorizing code such as "A", "B", or
"C"... Is there a way to count the rows that have an "A" code assigned to
them? I'm looking for a solution specifying something like "25 rows meet
the
"A" criterion".

Thank you...

Determine number of rows meeting a condition
 

Works will ALL versions - try it!
No one's PC exploded because they made typing error.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Snapps" wrote in message
...
...My mistake, I'm using Excel 2002. Is there a method that you know of
for
that version? Thanks again...

"Bernard Liengme" wrote:

I will assume Office XP refers to Excel 2003
Let's assume the column is D
If you want to sum all the A's in the entire column use
=COUNTIF(D:D,"A")
If you need to check only part of the column (rows 1 to 100, for example)
=COUNTIF(D1:D100,"A")

To make a fancy answer use
=COUNTIF(D:D,"A")&" rows meet the 'A' condition"
If you are a double-quotes person
=COUNTIF(D:D,"A")&" rows meet the ""A"" condition"
where there are two double-quotes each side of A

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Snapps" wrote in message
...
Within Office XP I need to count how many instances there are of a
condition
being met...
For example, a column is assigned a categorizing code such as "A", "B",
or
"C"... Is there a way to count the rows that have an "A" code assigned
to
them? I'm looking for a solution specifying something like "25 rows
meet
the
"A" criterion".

Thank you...