count number of times a word appears in a column

S

swino

I would like to produce a graph which counts the number of times 2 words
appear in a column:

online & offline to give me the total number of ports available i.e.
offline.

I would be very grateful if someone can point me in the right
direction.

Mike
 
T

Tushar Mehta

In XL help, look up COUNTIF

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 

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

How to count the numbers in a Word document? 0
How can the font and size of (all) citation numbers be altered? 1
Finding the proper style field and the numbered paragraph value within the style 0
Word VBA - Want to test if Full Name is NOT Present in document 0
SUMIFS ONLY UNTIL the number REPEATS 1
SUMIFS UNTIL the number is repeating 0
Move Chart with Text 0
Setting up a chapter a word-count inventory for a novel 1

Top