Sumif...else

[jdderrig]

I have 5 cells that I would like to sum only if they contain a number. If any contain text, I want the value to return as "NQ"

Cells:
G10:K10 will either contain text (Select One or N/A) or a number from 0-10

Is there a way to write a formula that says: sum if G10:K10 is >=0 else return "NQ"

Thanks

 

[jdderrig]

It also brings back 0 if I select N/A for the cells, not NQ

Hi & welcome to MrExcel.
How about
=IFERROR(1/(1/SUM(G10:K10)),"NQ")

I think that will work. Not exactly what I was looking for but I can live with that. Thanks so much!!

 

[Joe4]

Not exactly what I was looking for but I can live with that.

Take a look at my last post.