To count number of items with certain characters

[Ecel Dumbo]

Hi


Please suggest a formula to count the number of items below with the intial "BR"

A

1.00 AM

2.30 PM BR

1.23 AM

2.40 AM BR

6.20 PM BR

4.20 PM CR

4.20 PM KR


A formula to count how many items with BR initials


Thanks

Excel Dumbo

 

[NARAYANK991]

Hi ,


Use the COUNTIF function ; if your data is in the range A2:B8 , with the initials in column B , then the following formula :


=COUNTIF($B$2:$B$8,"BR")


will do the job.


Narayan

 

[Ecel Dumbo]

THanks a lot Narayan. If i use an * before or BR, ie =COUNTIF($B$2:$B$8,"*BR*") it works


=COUNTIF($B$2:$B$8,"BR"), used this and it returned me a zero value. But u gave me a head start.


By the way I am still looking in to the file that u had sent me earlier. I am still not able to open it. Anyways, we will discuss that later. THanks a lot for you help