adding up text

  • Thread starter Thread starter Altan
  • Start date Start date
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
 
=COUNTIF(A2:A500,"Disabled")

or better

=COUNTIF(A2:A500,B3)

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