Total number of things (Eg:word) in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know what formula to use to find the total number of things in a
column. For example if 'Strawberry' is written in column 'J' 10 times, I want
to have a seperate page that shows that information.
 
To get it all up at one go, try a pivot table: Insert a col label for col J,
eg: Fruit. Select col J, click Data > Pivot table & PivotChart report, click
Next > Next. Click Layout, then drag n drop Fruit into the ROW area, drag n
drop Fruit again into the DATA area (it'll appear as Count of Fruit). Click
OK, then Finish. The pivot table in the new sheet to the left should display
the desired results.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last number in a column shows in the total/summay line cell 3
Selecting a Keyword 3
Excel Subtracting multiple columns from another column 3
Running Total Column 1
calculating total in a column 2
Add/Subtract columns from tab to tab in same file 3
Total Number of Dups in 2 columns 1
Sum of different value in different worksheet & cell number 2

Back
Top