adding numbers but not letters
 

I have two columns of mainly numbers - I want to know if each column has a
number of 5 or over. Using IF(AND(D3=5, E3=5), "yes", "no") gives the right
answer unless there is a letter in one of the cells. How can I get it to
ignore all letters?

adding numbers but not letters
 

=IF(COUNT(D3:E3)=2,IF(AND(D3=5, E3=5), "yes", "no"),"no")
or
=IF(AND(COUNT(D3:E3)=2,D3=5, E3=5), "yes", "no")
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SoozeeC" wrote in message
...
I have two columns of mainly numbers - I want to know if each column has a
number of 5 or over. Using IF(AND(D3=5, E3=5), "yes", "no") gives the
right
answer unless there is a letter in one of the cells. How can I get it to
ignore all letters?

adding numbers but not letters
 

Hi,

Use Countif() :

=COUNTIF(D1:D5,"=5")

HTH

adding numbers but not letters
 

On Fri, 14 Dec 2007 04:39:01 -0800, SoozeeC
wrote:

I have two columns of mainly numbers - I want to know if each column has a
number of 5 or over. Using IF(AND(D3=5, E3=5), "yes", "no") gives the right
answer unless there is a letter in one of the cells. How can I get it to
ignore all letters?


=IF(AND(N(D3)=5, N(E3)=5), "yes", "no")


--ron

adding numbers but not letters
 

Many Thanks - that works fine

"Bernard Liengme" wrote:

=IF(COUNT(D3:E3)=2,IF(AND(D3=5, E3=5), "yes", "no"),"no")
or
=IF(AND(COUNT(D3:E3)=2,D3=5, E3=5), "yes", "no")
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"SoozeeC" wrote in message
...
I have two columns of mainly numbers - I want to know if each column has a
number of 5 or over. Using IF(AND(D3=5, E3=5), "yes", "no") gives the
right
answer unless there is a letter in one of the cells. How can I get it to
ignore all letters?