need help with formula
 

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

need help with formula
 

=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

need help with formula
 

Thanks Bob works great

slow hand

"Bob Phillips" wrote:

=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

need help with formula
 

My pleasure.

Bob

"slow hand" wrote in message
...
Thanks Bob works great

slow hand

"Bob Phillips" wrote:

=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