Can I Use a Count Function for Text?

Usually format to General or Number.

THEN ... click back in the formula bar and hit Enter to register the
change.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ldmci" wrote in message
...
I just found your discussion group. I also have two columns of information
and when I post the formula it simply appears as an entry. The cell where
I
posted the formula is a text cell. What should the cell format be?
Sorry!
This is all so new to me.
--
ldmci


"Steve Scatt" wrote:

Thanks Biff,

tried it again and made sure no unseen characters and it seems to work.
Cheers.

"Steve Scatt" wrote:

I have 2 separate columns and I am trying to count the nu,ber of
occurances
for a 2 different values. i.e. how many times admin column C and sick
Column
D show up. Tried the SUMPRODUCT and it doesn't seem to work. I get a
value of
0 when there should be 3.

"David Biddulph" wrote:

=SUMPRODUCT((A1:A100="A")*(A1:A100="D")*(B1:B100 ="psychiatrist"))
--
David Biddulph

"Nick Brunetti" wrote in
message
...
I am trying to count a cell if criteria from two separate columns
are met.

For example, my first column has the letters A, B, C, D or no
letters at
all. The second column has different descriptive words (i.e.
internal
medicine, psychiatrist, etc). I would like a cell to be counted if
a cell
in
the first column contains an A or B or C or D AND a cell in the
second
colum
contains the word "psychiatrist".

What is the best function/formula to use for this problem?

"Bob Phillips" wrote:

=COUNTIF(A1:A100,"*@*")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in
my
addy)



"Joan NYC" wrote in message
...
Aha... Sumproduct is not a function I ever tried

I have a column of text. Some cells contain the character "@"
with a
space
preceding the rest of text in the cell. I realize the @ could
be
considered
an operator so it is preceded with an apostrophe to designate
text. I
want
to sum the cells that have the "@"

Thanks

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do.
If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to
sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to
get
anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

eI am trying to put in the formula :
=COUNTIF(c4:c10, "cashiering")
to count recurrently rows of information.

The formula stays in the cell but the number does not materialize. I have
tried reformatting the cells to reflect number or general to no avail.

What am I doing wrong?

Cathy M

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. If COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

Format the cell as General.
With the cell still selected hit function key F2 then hit ENTER.

--
Biff
Microsoft Excel MVP


"Cathy M" Cathy wrote in message
...
eI am trying to put in the formula :
=COUNTIF(c4:c10, "cashiering")
to count recurrently rows of information.

The formula stays in the cell but the number does not materialize. I have
tried reformatting the cells to reflect number or general to no avail.

What am I doing wrong?

Cathy M

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get
anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

you saved my life, thanks for the post, my mgr will be pleased with the next
wave of spreadsheets

"Bob Phillips" wrote:

=COUNTIF(A1:A100,"*@*")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Joan NYC" wrote in message
...
Aha... Sumproduct is not a function I ever tried

I have a column of text. Some cells contain the character "@" with a
space
preceding the rest of text in the cell. I realize the @ could be
considered
an operator so it is preceded with an apostrophe to designate text. I
want
to sum the cells that have the "@"

Thanks

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get
anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

Hello,
I also just found the discussion group and this is probably an easy fix, but
everything I try give me an error.
I have a column of RSVP's....so in each cell I have either a "yes" or a
"no". I want a formula that will count the number of "yes"es so I know how
many people are coming to an event. I don't want to have to count by hand,
nor do I want to assign a value for each kind of response. I want Excel to
simply count "yes". Make sense?

kbrane

"ldmci" wrote:

I just found your discussion group. I also have two columns of information
and when I post the formula it simply appears as an entry. The cell where I
posted the formula is a text cell. What should the cell format be? Sorry!
This is all so new to me.
--
ldmci


"Steve Scatt" wrote:

Thanks Biff,

tried it again and made sure no unseen characters and it seems to work.
Cheers.

"Steve Scatt" wrote:

I have 2 separate columns and I am trying to count the nu,ber of occurances
for a 2 different values. i.e. how many times admin column C and sick Column
D show up. Tried the SUMPRODUCT and it doesn't seem to work. I get a value of
0 when there should be 3.

"David Biddulph" wrote:

=SUMPRODUCT((A1:A100="A")*(A1:A100="D")*(B1:B100 ="psychiatrist"))
--
David Biddulph

"Nick Brunetti" wrote in message
...
I am trying to count a cell if criteria from two separate columns are met.

For example, my first column has the letters A, B, C, D or no letters at
all. The second column has different descriptive words (i.e. internal
medicine, psychiatrist, etc). I would like a cell to be counted if a cell
in
the first column contains an A or B or C or D AND a cell in the second
colum
contains the word "psychiatrist".

What is the best function/formula to use for this problem?

"Bob Phillips" wrote:

=COUNTIF(A1:A100,"*@*")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Joan NYC" wrote in message
...
Aha... Sumproduct is not a function I ever tried

I have a column of text. Some cells contain the character "@" with a
space
preceding the rest of text in the cell. I realize the @ could be
considered
an operator so it is preceded with an apostrophe to designate text. I
want
to sum the cells that have the "@"

Thanks

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get
anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

=COUNTIF(A:A,"yes")

I wouldn't bother counting "no" because they aren't coming so you don't need
a knife and fork for them.


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 12:08:01 -0700, kbrane
wrote:

Hello,
I also just found the discussion group and this is probably an easy fix, but
everything I try give me an error.
I have a column of RSVP's....so in each cell I have either a "yes" or a
"no". I want a formula that will count the number of "yes"es so I know how
many people are coming to an event. I don't want to have to count by hand,
nor do I want to assign a value for each kind of response. I want Excel to
simply count "yes". Make sense?

kbrane

"ldmci" wrote:

I just found your discussion group. I also have two columns of information
and when I post the formula it simply appears as an entry. The cell where I
posted the formula is a text cell. What should the cell format be? Sorry!
This is all so new to me.
--
ldmci


"Steve Scatt" wrote:

Thanks Biff,

tried it again and made sure no unseen characters and it seems to work.
Cheers.

"Steve Scatt" wrote:

I have 2 separate columns and I am trying to count the nu,ber of occurances
for a 2 different values. i.e. how many times admin column C and sick Column
D show up. Tried the SUMPRODUCT and it doesn't seem to work. I get a value of
0 when there should be 3.

"David Biddulph" wrote:

=SUMPRODUCT((A1:A100="A")*(A1:A100="D")*(B1:B100 ="psychiatrist"))
--
David Biddulph

"Nick Brunetti" wrote in message
...
I am trying to count a cell if criteria from two separate columns are met.

For example, my first column has the letters A, B, C, D or no letters at
all. The second column has different descriptive words (i.e. internal
medicine, psychiatrist, etc). I would like a cell to be counted if a cell
in
the first column contains an A or B or C or D AND a cell in the second
colum
contains the word "psychiatrist".

What is the best function/formula to use for this problem?

"Bob Phillips" wrote:

=COUNTIF(A1:A100,"*@*")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"Joan NYC" wrote in message
...
Aha... Sumproduct is not a function I ever tried

I have a column of text. Some cells contain the character "@" with a
space
preceding the rest of text in the cell. I realize the @ could be
considered
an operator so it is preceded with an apostrophe to designate text. I
want
to sum the cells that have the "@"

Thanks

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get
anything
to
work.

Am I barking up the wrong tree? Can this be done?

Thanks much.

I have a similar problem I want to see how many of each text item are in a
column.
There only a dozen or so unique words out of a column of 450 rows but
that text is not static so I cant just use =COUNTIF(c4:c10, "text") as the
text value will change each month

Is there a way to get use the countif formula to read each cell text entry
and give me a total count of each text?

Thanks

Just to clarify. If I have a column that looks like this:
|Biscuits |
|Biscuits |
|Biscuits |
|Biscuits |
|Potatoes |
|Potatoes |
|Potatoes |
|Beef |
|Beef |
|Beef |
|Beef |
|Wine |

I want a result like this:
Wine = 1
Beef = 4
Potatoes = 3
Biscuits = 4

So that I dont have to type in Wine or beef in my formula. I need that
variable to be calculated and entered automatically. I know I can do it in
SQL but I dont want to have to create a database just for this....

Thanks


"Chgrec" wrote:

I have a similar problem I want to see how many of each text item are in a
column.
There only a dozen or so unique words out of a column of 450 rows but
that text is not static so I cant just use =COUNTIF(c4:c10, "text") as the
text value will change each month

Is there a way to get use the countif formula to read each cell text entry
and give me a total count of each text?

Thanks

Use a PivotTable.


Chgrec wrote:
Just to clarify. If I have a column that looks like this:
|Biscuits |
|Biscuits |
|Biscuits |
|Biscuits |
|Potatoes |
|Potatoes |
|Potatoes |
|Beef |
|Beef |
|Beef |
|Beef |
|Wine |

I want a result like this:
Wine = 1
Beef = 4
Potatoes = 3
Biscuits = 4

So that I dont have to type in Wine or beef in my formula. I need that
variable to be calculated and entered automatically. I know I can do it in
SQL but I dont want to have to create a database just for this....

Thanks


"Chgrec" wrote:

I have a similar problem I want to see how many of each text item are in a
column.
There only a dozen or so unique words out of a column of 450 rows but
that text is not static so I cant just use =COUNTIF(c4:c10, "text") as the
text value will change each month

Is there a way to get use the countif formula to read each cell text entry
and give me a total count of each text?

Thanks

That is exactly what I neded, Thanks!!

Chris

"Glenn" wrote:

Use a PivotTable.


Chgrec wrote:
Just to clarify. If I have a column that looks like this:
|Biscuits |
|Biscuits |
|Biscuits |
|Biscuits |
|Potatoes |
|Potatoes |
|Potatoes |
|Beef |
|Beef |
|Beef |
|Beef |
|Wine |

I want a result like this:
Wine = 1
Beef = 4
Potatoes = 3
Biscuits = 4

So that I dont have to type in Wine or beef in my formula. I need that
variable to be calculated and entered automatically. I know I can do it in
SQL but I dont want to have to create a database just for this....

Thanks


"Chgrec" wrote:

I have a similar problem I want to see how many of each text item are in a
column.
There only a dozen or so unique words out of a column of 450 rows but
that text is not static so I cant just use =COUNTIF(c4:c10, "text") as the
text value will change each month

Is there a way to get use the countif formula to read each cell text entry
and give me a total count of each text?

Thanks