if meets criteria add 1
 

i need a formula that will look at a text/number in a column and go down the
column and add 1 to get a total number of items meeting the criteria.

example
column D
1, 2P
1P, 2, 3
1, 2
2
1P

how do i get it to search for a 1 in the string of text in column D and give
me the answer of 4 for the number of times it shows up in that column?
Thanks.

if meets criteria add 1
 

Hi,

=SUMPRODUCT((LEFT(D1:D10,1)="1")*(1))

Mike

"r2rcode" wrote:

i need a formula that will look at a text/number in a column and go down the
column and add 1 to get a total number of items meeting the criteria.

example
column D
1, 2P
1P, 2, 3
1, 2
2
1P

how do i get it to search for a 1 in the string of text in column D and give
me the answer of 4 for the number of times it shows up in that column?
Thanks.

if meets criteria add 1
 

Try this formula:
=SUMPRODUCT(--ISNUMBER(SEARCH("1",D1:D1000)))


"r2rcode" wrote:

i need a formula that will look at a text/number in a column and go down the
column and add 1 to get a total number of items meeting the criteria.

example
column D
1, 2P
1P, 2, 3
1, 2
2
1P

how do i get it to search for a 1 in the string of text in column D and give
me the answer of 4 for the number of times it shows up in that column?
Thanks.