# Countif help

#### neditheg

##### New Member
Hy guys .. I need some help.

I want a formula to count how many "1" have "ok" , how many "2" have "ok" and soo on..

Last edited:

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

##### MrExcel MVP
Try something like:

=SUMPRODUCT(--(\$A\$2:\$A\$100=1),--ISNUMBER(SEARCH("ok",\$B\$2:\$B\$100)))

#### neditheg

##### New Member
I'm using the countif formula to count how many "1"..."12" I have in the first column ... but after this operation I want to know how many 1---whit ok are in my sheet .. then how many "2" with ok .. etc..

I've tried the sum(if(..)) statement but with no good result :|

help!?

##### MrExcel MVP
I'm using the countif formula to count how many "1"..."12" I have in the first column ... but after this operation I want to know how many 1---whit ok are in my sheet .. then how many "2" with ok .. etc..

I've tried the sum(if(..)) statement but with no good result :|

help!?

#### neditheg

##### New Member
Try something like:

=SUMPRODUCT(--(\$A\$2:\$A\$100=1),--ISNUMBER(SEARCH("ok",\$B\$2:\$B\$100)))

ok --> =SUMPRODUCT(--(\$A\$2:\$A\$100=L2);--ISNUMBER(SEARCH("ok";\$E\$2:\$E\$100)))

this works thanks!!

##### MrExcel MVP
ok --> =SUMPRODUCT(--(\$A\$2:\$A\$100=L2);--ISNUMBER(SEARCH("ok";\$E\$2:\$E\$100)))

this works thanks!!

Just for the record...

The following will also work:

=SUM(IF(\$A\$2:\$A\$100=L2;IF(ISNUMBER(SEARCH("ok";\$E\$2:\$E\$100));1)))

which is confirmed with control+shift+enter, not just with enter.

#### neditheg

##### New Member
i know ... thanks a lot

I'll try this too

It works !!!

Replies
2
Views
225
Replies
1
Views
405
Replies
7
Views
371
Replies
1
Views
78
Replies
1
Views
252

1,191,213
Messages
5,985,309
Members
439,956
Latest member
FrazzledCat

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back