Creating a table to count data in a column

[howsyourdad?]

Type of licence
Scaffold
Hoarding
Skip
Skip
Hoarding

Hello all, I want to create a way of quickly counting data (as shown above) Ito create a spreadsheet with a summary table that automatically counts the number of applications in a given month. I presume I need a formula for this? So, in a column like the above i want a table that turns the text, for example 'skip' into a countable number.my table would then give results as shown:



Type Amount of apps.
Hoarding 1
Mixed 0
Scaffold 1
Skip 2


Many thanks in advance, this would really be of great assistance!

[arthurbr]

Depending on what you want to achieve there arte many solutions
One of thme is Data - Subtotals - Select" Count" - OK

[Jazzer]

Hi,

You can use COUNTIF to do that. Let's say that your data is in column A and your summary list starts from C1:

Hoarding
Mixed
Scaffold
Skip

In D1 put this formula:

=COUNTIF(A:A,C1)

and copy it down as long as you need (in this case in cell D4).

- Asser

[yknet]

Type of licence
Scaffold
Hoarding
Skip
Skip
Hoarding

Hello all, I want to create a way of quickly counting data (as shown above) Ito create a spreadsheet with a summary table that automatically counts the number of applications in a given month. I presume I need a formula for this? So, in a column like the above i want a table that turns the text, for example 'skip' into a countable number.my table would then give results as shown:


Type Amount of apps.
Hoarding 1
Mixed 0
Scaffold 1
Skip 2


Many thanks in advance, this would really be of great assistance!

You can count using the formula "COUNTIF". And you would like to get the counting number in a table, you can use pivottable function.

You are not very familier with these function, let me know.

[howsyourdad?]

Wonderful.Thanks very much for the help.

Martin