If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Data in a Column
Hello all,
I am working on a spread sheet that has various columns of text. In each column, it is important to note that there will be some duplicate data. Under each column, I would like to have excel "summarize" the data. Consider the following example: column 1 column 2 ------------------------- A X A Y B Y C X B Z A Y Totals ------------------------ A 3 X 2 B 2 Y 3 C 1 Z 1 (I hope this formatting is posted correctly!) As shown above, I would like to have excel sum the duplicate entries of each column below. Is there anyway to do this? Thanks in advance! Francis |
#2
|
|||
|
|||
Counting Data in a Column
=COUNTIF(A:A,"A")+COUNTIF(B:B,"A")
etc. -- HTH RP (remove nothere from the email address if mailing direct) "Francis" wrote in message ... Hello all, I am working on a spread sheet that has various columns of text. In each column, it is important to note that there will be some duplicate data. Under each column, I would like to have excel "summarize" the data. Consider the following example: column 1 column 2 ------------------------- A X A Y B Y C X B Z A Y Totals ------------------------ A 3 X 2 B 2 Y 3 C 1 Z 1 (I hope this formatting is posted correctly!) As shown above, I would like to have excel sum the duplicate entries of each column below. Is there anyway to do this? Thanks in advance! Francis |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
Countif with 2 or more data ranges in same column | Doug | Worksheet Functions | 1 | July 4th, 2004 08:57 AM |
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive) | M Stokes | Worksheet Functions | 1 | April 26th, 2004 04:33 PM |