Jul 28 2019 06:13 PM
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
Jul 28 2019 11:31 PM
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