Counting number of times a phrase appears

[pbhogal]

Hello

Suppose that I have a column that has names of journals.

Lets say that I want to count how many times that journal appears in the column.

Suppose that there are many different journals, all with different titles, and I want to count each appearance so as to create a histogram later.

Is this possible without explicitly giving the names of each journal, searching and using the count function ?

Many thanks.

 

[marka87uk]

Yes, you can use the COUNTIF function.

=COUNTIF('YourRange','YourCriteria')

 

[Jared_8878]

throw the data into a pivot table with a pivot chart.