Count and summarise records in Excel 2003
Solved/Closed
Related:
- Count and summarise records in Excel 2003
- Number to words in excel - Guide
- How to count names in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
2 responses
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")
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")