=COUNTIF(G18:G41,2)

=SUMPRODUCT(--(G18:G41=2),--((N18:N41="4A")+(O18:O41="4A")))

--
HTH

Bob Phillips

"slow hand" wrote in message
...
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