Checking on first two digits of field

[The Fool on the Hill]

Dear All,

I have a list of issues. All issues are indicated by a code a : and the
issueremark.

Now I want to know how many issues are registered with a special code:
T2: CC-009 (FI-item list) runs over 5 hours
T2: CC-002 (Hash tables): bad performance of ZEXTR_KEYS_HASH1
T1: Issue on FAD_Counting_Control_V10.doc
T1: Berekening HASHTOTAL CC002 - berekening meterstanden klopt niet
T3: Incorrect text in outcome AL11 and ZEXTR_ZEXTR for CC016

I want some kind of formula that gives me the number of issues starting with
T1 (=2), T2 (=2) and T3 (=1).

Something like:
Countif(A1:A5), where first two digits = T1

Can you help me, please?

Thank you !

 

[Rick Rothstein \(MVP - VB\)]

Try this...

=COUNTIF(A1:A8,"=T1:*")

Rick

 

[Gav123]

Hi,

For T1 Codes..

=COUNTIF(A1:A5,"T1*")

Replace T1 with T2 or T3

Hope this helps,

Gav.

 

[The Fool on the Hill]

Thanks Gav and Rick,

Exactly what I am looking for !!!

Now I have a new column with status in B.
Column A Column B
------------------------------------------------------
T2: CC-009 Open
T2: CC-002 New
T1: Issue on FAD Closed
T1: Berekening HASHTOTAL Open
T3: Incorrect text Closed

Now I am looking for a formula which gives me the following result:
T1 Closed 1
T1 Open 1
T2 New 1
T2 Open 1
T3 Closed 1

Can you please help me again ?

 

[The Fool on the Hill]

How does that work with a pivot table if you are only looking for the first
two digits of a field?