LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default Counting categories

This is most likely a question which has been asked before. If so let me apologise beforehand. (If it has been asked before I cannot find it)

I have a membership database of about 950 members.

There is a column headed 'Status'. This column can have 6 different entries.

How can I produce the count of each category? (as a Printed report)

i.e. AS = 2, SM = 628, SS = 187, LS = 123, LM = 10

I am using excel 2010

Last edited by artytac : February 7th 11 at 09:34 AM Reason: additional information
 
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
Formula Help for Counting categories in a column Patti Excel Worksheet Functions 3 April 24th 09 04:14 AM
counting unique items within categories Btaylor64 Excel Worksheet Functions 7 October 3rd 08 06:19 PM
Counting using 2 categories Nick Horn Excel Discussion (Misc queries) 2 May 1st 08 09:38 PM
Counting categories tryn2learn Excel Discussion (Misc queries) 1 February 27th 08 11:36 PM
counting categories of text cells Brownjc96 Excel Discussion (Misc queries) 3 May 30th 05 01:37 PM


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

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

About Us

"It's about Microsoft Excel"