Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |