summing specifc state abbreviations in a column
 

I have a list of addresses and would like to sum the number of addresses in
each state. There is a column with the 2 letter state abbreviation for each
address. How can I do this? I have never summed actual text in a column before

summing specifc state abbreviations in a column
 

hI,
I assume your addresses are in column A and the 2 letter state in Column B,
create a list of all the States posibles in column c and in column D enter (
I suppose your list starts in D1

=COUNTIF($b$1:$B$100,D1)

Copy formula down change the range to fit your needs

"Kathy S" wrote:

I have a list of addresses and would like to sum the number of addresses in
each state. There is a column with the 2 letter state abbreviation for each
address. How can I do this? I have never summed actual text in a column before

summing specifc state abbreviations in a column
 

Countif() is what you want to use.

Say your datalist is in A2 to K100, with the state in Column J.

You could just add another column to your datalist, and use this formula to
return the count of each state in each row:

In L2 enter:
=Countif(J$2:J$100,J2)

and copy down to L100.

This would of course return duplicate results for each row with the same
state.

OR

You could make a separate list of all 50 states, say in M1 to M50,
and then enter this formula in N1, and copy down:

=Countif(J$2:J$100,M1)


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Kathy S" <Kathy wrote in message
...
I have a list of addresses and would like to sum the number of addresses in
each state. There is a column with the 2 letter state abbreviation for each
address. How can I do this? I have never summed actual text in a column
before