Count Text in Column?

nastech · Mar 22, 2006

Hi, trying to find way to count occurances of text in a column, thanks.

=COUNT(LEFT(R100:R3000,1)="x")

Stefi · Mar 22, 2006

=SUMPRODUCT(--(LEFT(R100:R3000,1)="x"))

Regards,
Stefi

â€žnastechâ€ ezt Ãrta:

Dave Peterson · Mar 22, 2006

Another way:

=COUNTIF(R100:R3000,"x*")

Hi, trying to find way to count occurances of text in a column, thanks.

=COUNT(LEFT(R100:R3000,1)="x")