=IF Formula

[frankiiie]

Hi, I need help setting up the following formula;

If value is Win then add all the value up and divided by (value in a cell)<the value="" in="" the="" cell="">.
If value is Loss then add all the value up and divided by (value in a cell)<the value="" in="" the="" cell="">.
If value is Square then add all the value up and divided by (value in a cell)<the value="" in="" the="" cell="">.

So basically to calculate the percentages of Win, Loss and Square. Cheers!</the></the></the>

 

[Joe4]

So basically to calculate the percentages of Win, Loss and Square.

Let's say that your entries of "Win" ,"Loss", and "Square" appear in cells A1:A10.
Here is how you get the percentage of "Win" entries:

=COUNTIF(A$1:A$10,"Win")/COUNTA(A$1:A$10)

The other two would use the same formula, just change the word "Win" to "Loss" and "Square".