Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 25th 05, 04:38 PM posted to microsoft.public.excel.worksheet.functions
Francis
 
Posts: n/a
Default 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   Report Post  
Old November 25th 05, 05:11 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format based on data from another column Ellie Excel Discussion (Misc queries) 3 May 14th 08 05:23 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
2 Column Data lookup Hari Excel Discussion (Misc queries) 2 June 15th 05 07:54 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
SUMPRODUCT Formula to Count Row of data Below Matched Criteria Sam via OfficeKB.com Excel Worksheet Functions 8 February 3rd 05 01:37 AM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017