Need help with a spreedsheet

Copper Contributor

i have two columns in a spreedsheet. the first showing won/lost the second showing a $ amount.

what i need is a formula or function to show me the won/loss as a percentage with the amount won in $

thanks guys

1 Reply

@Wast3d7432 

following is "Lost" percentage

=100*SUMIF($A$2:A10,"Lost",$B$2:$B$10)/SUMIF($A$2:A10,"Won",$B$2:$B$10)

 

assumption : column A has Won/Lost information and and B has amount. please modify the column range as needed