How to count occcurence of specific text block in a column

I want to count how many times initials of employees (e..g AD, AS, RR, AN,
VB, DO) appear in a specific column. I am using COUNT IF function for that.

The problem is as soon as I put initials fof 2 employees in one cell, the
formula does not recognise either of them.

To give you a gist, I want to see how many people work out of office , so I
have a calendar style worksheet( month=col, date=row). If I input AD on 13
day of jan, , I get 1 for AD, in the row where I am collecting total for AD .
But if I put both AD, AS on 13 jan, then neither AD nor AS gets recognised.

Please advise a suitable formula or an alternative method.
Thanks

=countif(a:a,"*ad*")

Make sure you use a separator between each person.



Anshuman wrote:
>
> I want to count how many times initials of employees (e..g AD, AS, RR, AN,
> VB, DO) appear in a specific column. I am using COUNT IF function for that.
>
> The problem is as soon as I put initials fof 2 employees in one cell, the
> formula does not recognise either of them.
>
> To give you a gist, I want to see how many people work out of office , so I
> have a calendar style worksheet( month=col, date=row). If I input AD on 13
> day of jan, , I get 1 for AD, in the row where I am collecting total for AD .
> But if I put both AD, AS on 13 jan, then neither AD nor AS gets recognised.
>
> Please advise a suitable formula or an alternative method.
> Thanks

--

Dave Peterson

=COUNTIF(A:A,"*AD*")

should work.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I want to count how many times initials of employees
(e..g AD, AS, RR, AN,
>VB, DO) appear in a specific column. I am using COUNT IF
function for that.
>
>The problem is as soon as I put initials fof 2 employees
in one cell, the
>formula does not recognise either of them.
>
>To give you a gist, I want to see how many people work
out of office , so I
>have a calendar style worksheet( month=col, date=row).
If I input AD on 13
>day of jan, , I get 1 for AD, in the row where I am
collecting total for AD .
>But if I put both AD, AS on 13 jan, then neither AD nor
AS gets recognised.
>
>Please advise a suitable formula or an alternative
method.
>Thanks
>.
>