Countif help

[neditheg]

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..

 

[Aladin Akyurek]

Try something like:

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

 

[neditheg]

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!?

 

[Aladin Akyurek]

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!?

See my reply...

 

[neditheg]

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!!

 

[Aladin Akyurek]

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]

i know ... thanks a lot

I'll try this too

 

[neditheg]

It works !!!