I would like to figure out the percentage of units sold. I have 4 possible
products to sell each customer. I already have it so if i enter an amount
greater than 1 under one of the products, i get a 1 in a cell and if i dont
enter an amount i get a zero using the formula "=IF($G21,"1","0")". I would
like to have it calculate the percentage based on each customer. For
example, if in row 2(customer1) i sell a product, it should display 100%.
Then in row 3 (customer 2) i do not sell a product, it should display 50%
without changing the 100% in row 2.

I hope this makes as much sense to you as it does to me. I can give a more
detailed explanation for anyone who is willing to help.