Sales Contacts

Assuming you're not going to sell any without a contact
1. Under the "Contact %", I would like a percentage of contacts make, successfully.
=COUNTIF(H4:H60,"Y")/COUNTA(H4:H60)

2. Under the "Apt %", how many of those successfully contacted with (from contact %), made an appointment.
=COUNTIF(H4:H60,"Y")/COUNTIF(H4:H60,"Y")

3. Under the "Showed %", how many of those successfully contacted with (from contact %), had a product shown to them.
=COUNTIF(J4:J60, "Y")/COUNTIF(H4:H60,"Y")

4. Under the "Sold %", how many of those successfully contacted with (from contact %), made a sale.
=COUNTIF(K4:K60,"Y")/COUNTIF(H4:H60,"Y")

5. Under the "Sold %", how many of those successfully contacted with (from showed %), made a sale.
=COUNTIFS(K4:K60,"Y", J4:J60, "Y", H4:H60,"Y")/COUNTIFS(H4:H60,"Y", J4:J60, "Y")

Here are the five formulas to be used-

Please Login or Register  to view this content.

Format the cells as "Percentage"

Check attached.
NOTE :- You need to have a customer name field. Total is calculated from the number of customers.

Not sure if the user wants the percentage from the total customers or as done by @ChemistB