If Formula and Countif

[Aladin Akyurek]

On 2002-01-14 16:22, justine wrote:
I asked it wrong before, so I'll try again.

I need a formula that will count how many NS are in E20 thru M20 also, I need in the same formula to enter a N/A if there are Quit or Inj in the same E20 thru M20. is that possible? (Also, I need it to return a blank cell if there aren't any NS, Quit or Inj entered.

Thanks!
This message was edited by justine on 2002-01-14 16:23

All this in the same formula?

 

[justine]

I asked it wrong before, so I'll try again.

I need a formula that will count how many NS are in E20 thru M20 also, I need in the same formula to enter a N/A if there are Quit or Inj in the same E20 thru M20. is that possible? (Also, I need it to return a blank cell if there aren't any NS, Quit or Inj entered.

Thanks!
This message was edited by justine on 2002-01-14 16:23

 

[justine]

Yes.. Is that possible?

 

[daleyman]

=IF(COUNTIF(E20:M20,"Quit")>0,"N/A",IF(COUNTIF(E20:M20,"Inj")>0,"N/A",IF(COUNTIF(E20:M20,"NS")>0,COUNTIF(E20:M20,"NS"),"")))

 

[Aladin Akyurek]

On 2002-04-15 06:00, justine wrote:
Yes.. Is that possible?

No, unless the data are such that only one of the conditions holds, for example,

when CountOf(NS)>0, Quit and NJ do not occur in the range.

Aladin