Thanks:  0
Likes:  0

# Thread: If Formula and Countif

1. 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?

2. 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 ]

3. Yes.. Is that possible?

4. =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"),"")))

5. 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.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•