Counting occurences of a string

[Garage23]

Hey Guys,

I tried using counif statement, but that doesn look like it will work.

What I have is a column with multiple pieces of data and I would like to account for the occurences a certain string appears in the column

A
1) 11
13
13.1
12
------------------
2) 13

So my primary goal would be for the example above is to count all the occurences of just "13"(not 13.1) in column A

My secondary would be able to use a cell reference in all of this, ie find all occurences of B1

I look forward to suggestions

[Trebor76]

Hi there,

The following formula (in whatever cell you choose to house it in) returns the desired result for me:

=COUNTIF($A$1:$A$4,13)

HTH

Robert

[Garage23]

I think my original post wasn't clear so I attached an example.

In the attached example I would like to count how any times bfs2 occurs in column A

[martindwilson]

see attached put string in b1 result in c1

[DonkeyOte]

I think you want:

C1:
=SUMPRODUCT((LEN($A$2:$A$5&CHAR(10))-LEN(SUBSTITUTE($A$2:$A$5&CHAR(10),$B$1&CHAR(10),"")))/LEN($B$1&CHAR(10)))

where B1 holds bfs2

the above will conduct exact matches (ie bfs2.1 not a match)

assumes a line break delimiter per the example

[martindwilson]

i missed that i thought it was all occurences but having re read original post

just "13"(not 13.1)

that looks just the ticket!

[Garage23]

Thanks for the responses. I used DonkeyOte's solution