Excel formula to return different results for all cells equal to, blank or count of a value

I am trying to create a formula that will look at a column of cells and do the following;

• if all cells blank then return no value
• if some cells "Unapproved" then count and show the number of these
• if all cells "Approved" then return "All Approved"

This is as far as got but will appreciate any help. This is an array; =IF(ISBLANK(AD14:AD23)," ",CONCATENATE(COUNTIF(AD14:AD23,"Unapproved")," Awaiting Approval"))

Look forward to hearing from you.