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