Search : in
By :

Count and summarise records in Excel 2003

Last answer on Feb 17, 2009 9:37:25 am GMT GRA, on Feb 16, 2009 10:01:52 am GMT 
 Report this message to moderators

Hello,
Sorry to bother you but I have a minor problem with a spreadsheet and I don't know how to resolve the issue or whether it is possible using standard functionality in the product. All I need to know is - what is the function or should I be using a different approach to calculate and produce the summary table as shown below.


What I'm looking for is this = Description Number of Records

Start Provision 7
Leave Provision 7
Short Outcome 11
Sustained Outcome 5

I've tried using the COUNTA function which tells me the number of lines in the worksheet which have nonblanks but I wanted to summarise these by stating the number of records that match a specific Description e.g. 'Start Provision' and count the number of records that have that description.

Is this possible please?....Any guidance appreciated......Thanks...GRA


Input Data

Start Provision
Start Provision
Leave Provision
Short Outcome
Short Outcome
Short Outcome
Short Outcome
Start Provision
Leave Provision
Start Provision
Leave Provision
Short Outcome
Sustained Outcome
Short Outcome
Short Outcome
Start Provision
Leave Provision
Short Outcome
Sustained Outcome
Start Provision
Leave Provision
Short Outcome
Sustained Outcome
Start Provision
Leave Provision
Short Outcome
Sustained Outcome
Start Provision
Leave Provision
Short Outcome
Sustained Outcome

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Count and summarise records in Excel 2003 » in :
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Difference between dates with the DATEDIF function ShowDifference between dates with the DATEDIF function The Syntax Example Making use of: Notes The DATEDIF function is not documented in Excel, here are some informations about it The Syntax =DATEDIF(start date;end date;type of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

Helper, on Feb 16, 2009 9:16:36 pm GMT

You could use the COUNTIF function.
Let's assume your input data was in the range A1:A31, you can use =COUNTIF(A1:A31,"Start Provision")

Fiirst you specify the range. Then, you specify the criteria you want to count.
Use that formula for each item you want to count.


=countif(A1:A31,"Start Provision")
=countif(A1:A31,"Leave Provision")
=countif(A1:A31,"Short Outcome")
=countif(A1:A31,"Sustained Outcome")

   
Reply to Helper

2

 GRA, on Feb 17, 2009 9:37:25 am GMT

Many thanks, this is exactly what I wanted to achieve. Much appreciated. Regards, GRa

   
Reply to GRA
Ask your question Reply
They need your help