Need to total a column with text in it?

Closed
ClaireDoherty Posts 1 Registration date Sunday July 20, 2014 Status Member Last seen July 20, 2014 - Jul 20, 2014 at 06:08 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 20, 2014 at 09:07 AM
Hi

I am looking to total a column that has specific text in it.

e.g My column has the words Leave, Public Holiday or Sick in it so at the bottom I want to total how many days leave has been used and how many days sick?

Can someone please help?
Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 20, 2014 at 09:07 AM
ClaireDoherty, Good morning.

Try to use it:
=COUNTIF(A1:A100,"Leave")
=COUNTIF(A1:A100,"Sick")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1