Count

[How_Do_I]

How would I do this please. I want to know how many cells in the range A1:D5 start with 28 and how many start with 57d. My Jeanie is a sample, I'm not after cells that contain 28 for example, whatever I'm trying to count must be from the left.

Excel Workbook
	A	B	C	D	E	F	G
1	28.B.6	28.C.1	57d.Q.3	28.C.2		28
2	28.B.12	28.C.7	57d.Q.9	28.C.8		57d
3	28.B.18	28.C.13		28.C.14
4		28.C.19		28.C.20
5	28.B.30	28.C.25	57d.Q.27	28.C.28
Sheet8

 

[Joe4]

Try:
=COUNTIF(A$1:D$5,"28*")
and
=COUNTIF(A$1:D$5,"57d*")

 

[AlanY]

try

=COUNTIF($A$1:$D$5,F1&"*")

and copy down

 

[How_Do_I]

Lovely, thanks Joe, thanks Alan.

 

[AlanY]

you're welcome

 

[How_Do_I]

Actually I think there's a problem still. In my workbook some cells start with "36" and some with "36c". So those solutions won't deal with that will they?

 

[Joe4]

They should work just fine.
You can count all the records that start with "36".
And you can count all the records that start with "36c".
If you want a count of all the records that start with "36", but NOT include those that start with "36c", just subtract the one from the other, i.e.
=COUNTIF(A$1:D$5,"36*") - COUNTIF(A$1:D$5,"36c*")

 

[How_Do_I]

In case anyone else is looking for a similar solution I used the "." which appear in all my data and instead of " 28 " (Number) I used " '28. " (Text) and the following formula in G1 copied down.

Excel Workbook
	A	B	C	D	E	F	G
1	28.B.6	28.C.1	57d.Q.3	28.C.2		28.	13
2	28.B.12	28.C.7	57d.Q.9	28c.C.8		57d.	3
3	28.B.18	28.C.13		28.C.14		28c.	1
4		28.C.19		28.C.20
5	28.B.30	28.C.25	57d.Q.27	28.C.28
Sheet8