Untitled

=IF(C2="All three", 
   "Overall: "&COUNTIFS($C:$C, C2, $D:$D, "For review")&" For Review | " & COUNTIFS($C:$C, C2, $D:$D, "Accepted")&" Accepted", 
   IF(C2="Homepage", 
      "Homepage: "&COUNTIFS($C:$C, C2, $D:$D, "For review")&" For Review | "&COUNTIFS($C:$C, C2, $D:$D, "Accepted")&" Accepted",
   IF(C2="Product Hub", 
      "Product Hub: "&COUNTIFS($C:$C, C2, $D:$D, "For review")&" For Review | "&COUNTIFS($C:$C, C2, $D:$D, "Accepted")&" Accepted",
   IF(C2="Contact Us", 
      "Contact Us: "&COUNTIFS($C:$C, C2, $D:$D, "For review")&" For Review | "&COUNTIFS($C:$C, C2, $D:$D, "Accepted")&" Accepted", 
   "Invalid Entry")))))