adding up text

A

Altan

My Excel spreadsheet has a column that has either Enable
or Disable in it.
How can I have the spreadsheet automatically add these
text values so that I would know how many times I have
written Disabled and how many times I have written Enabled?
Thanks
Altan
 
P

Peo Sjoblom

=COUNTIF(A2:A500,"Disabled")

or better

=COUNTIF(A2:A500,B3)

where you type in the words you want to check in B3
 

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

Need Help with Macro Security 1
Move Chart with Text 0
Word OLE to check spelling in text box 1
Excel does not accept text format! 0
OLE Word spelling 0
New documents automatically have text in superscript 0
Mail Merge Directory Conditional Page Break 0
Function in Excel to count and list number of entries of text valuesin a row. 2

Top