Re: countif

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

=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
.