Leaving the sheet as you have it would require summing the 5 different percentages. In other words you would take the formula already given but change the BOOKED (100%) to PENDING (95%) then add the same formula but changed to VERY LIKELY (75%) then add....etc until the last one. So you end up with 5 SUMPRODUCT()'s added together.