formula

[jaco]

I have a database that looks like this

A

1287
1287-3345
1287-6785

I want to write a formula that can count the number of times 1287 has occured in the same column.

Thanks in advance

 

[Aladin Akyurek]

On 2002-04-10 04:42, jaco wrote:
I have a database that looks like this

A

1287
1287-3345
1287-6785

I want to write a formula that can count the number of times 1287 has occured in the same column.

Thanks in advance

Try:

=SUMPRODUCT(ISNUMBER(SEARCH(E1,A1:A3))+0)

where A1:A3 is the range of interest and E1 houses the target value to count.

Addendum: If the range of interest houses text-formatted entries only,

=COUNTIF(A1:A3,"*"&E1&"*")

will suffice.
This message was edited by Aladin Akyurek on 2002-04-10 05:31

 

[Dave Hawley]

Hi Jayco

Man=ybe even:

=COUNTIF(A1:A5000,1287)+COUNTIF(A1:A5000,"1287*")