Multiple IF criteria, return alternative value from multiple IF criteria

Hi,
I am stuck with a formula that looks simple but that is not working. Actually, I have 8 columns as follows: A2 for action items, B2 for start date, then a rage of C2, D2, E2 and F2 for the four weeks of the month; and then G2 for action closure date, and finally H2 for action status. Now, I want is this:
1) IF A2 is blank, then H2 should show "blank"
2) IF A2 contains text (action items), then H2 should show "Open"
3) IF B2 contains date (action resolution start date), then H2 should show "Ongoing"
4) IF range (C2:F2) contains "Ok", OR G2 contains date (resolution completion date), then H2 should show "closed"

The formula I tried is: =IF(A2="","",IF(ISNUMBER(B2),"Ongoing",IF(OR(COUNTIFS(C2:F2,"ok"),ISNUMBER(G2)),"Closed","Open")))
But it works only on the first 3 criteria, but would not work on the last. So, I can get Blank, Open, and Ongoing, but I can't get Closed.

Please help!

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

Still no workbook, though ...

And your profile still hasn't been updated.

Try this:

=IF(A2="","",IF(OR(COUNTIF(C2:F2,"ok")>=1,ISNUMBER(G2)),"Closed",IF(ISTEXT(A2),"Open","Ongoing")))

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.