MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COUNTIF help


Posted by James on April 05, 2001 8:52 AM

I have a column of data and I would like to be able to count the number of rows that have say "xx" as the starting characters in the columns. Is this possible and if so, can some help out with this?

Thanks,


Posted by Aladin Akyurek on April 05, 2001 8:56 AM

Try the following array-formula:

=SUM(IF(LEFT(A1:A3,2)="xx",1,0))

You need to hit CONTROL+SHIFT+ENTER at the same time to enter this formula.

Aladin

Posted by Mark W. on April 05, 2001 8:58 AM

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

Posted by James on April 05, 2001 9:16 AM

Worked Great...Thankx......n/t

.

Posted by Aladin Akyurek on April 05, 2001 9:26 AM

Re: Worked Great...Thankx......n/t

Just curious: Which one?