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

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.

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

=COUNTIF(Sheet1!J:J,"Strawberry")

"Reana" wrote in message ...

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Reana" wrote:
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.