I want to count the occurrences of multiple character strings eg. "AB" "XD"
and "CD". Is there an easier way than = (countif(1:100), "AB") +
(countif(1:100), "XD") etc.
I want to count the occurrences of multiple character strings eg. "AB" "XD"
and "CD". Is there an easier way than = (countif(1:100), "AB") +
(countif(1:100), "XD") etc.
=SUM(COUNTIF(A1:a100,{"AB","xd","cd"}))
AJ wrote:
>
> I want to count the occurrences of multiple character strings eg. "AB" "XD"
> and "CD". Is there an easier way than = (countif(1:100), "AB") +
> (countif(1:100), "XD") etc.
--
Dave Peterson
Thank you! Exactly what I am looking for. I tried to put something like
this together but didn't realize that I would have to use "SUM" and I admit
that I don't know when to use the characters "{" and "}" in a formula.
"Dave Peterson" wrote:
> =SUM(COUNTIF(A1:a100,{"AB","xd","cd"}))
>
> AJ wrote:
> >
> > I want to count the occurrences of multiple character strings eg. "AB" "XD"
> > and "CD". Is there an easier way than = (countif(1:100), "AB") +
> > (countif(1:100), "XD") etc.
>
> --
>
> Dave Peterson
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks