I have a range of cell I want to count ,,say the 2's but with this formula
,,,,=SUMPRODUCT(--(ISNUMBER(FIND("2",G18:G41)))) I count not only the 2's by
them selfs but also the 2's in 22 or 12 etc..giving me the wrong results...
Also I want to count the 2's only if this range of cells,,,,, N18:O41 has 4A
entered into it... can some one help.

slow hand