Hi:

I have tried many variations of different nested formulas and have had no
luck solving this one.

Here are the two scenarios that I am trying to accomplish:
Scenario 1:
Count 1 if the following criteria are met on a single line of data:
Col F contains text (is not blank)
Col G, H, and I do NOT contain "Dropped"

Scenario 2:
Count 1 if the following criteria are met on a single line of data:
Col F contains text (is not blank)
Col G, H, I all contain the word "Approved" or "N/A" - the tricky part is
that there are several different variations of Approved so I tried using the
wildcard "*Approved*" but it doesn't seem to work in this particular formula.

The two scenarios are separate from eachother. Any help is appreciated!
Thanks.