Home

Need help with a spreedsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-776811%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20a%20spreedsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776811%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20two%20columns%20in%20a%20spreedsheet.%20the%20first%20showing%20won%2Flost%20the%20second%20showing%20a%20%24%20amount.%3C%2FP%3E%3CP%3Ewhat%20i%20need%20is%20a%20formula%20or%20function%20to%20show%20me%20the%20won%2Floss%20as%20a%20percentage%20with%20the%20amount%20won%20in%20%24%3C%2FP%3E%3CP%3Ethanks%20guys%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776811%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776957%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20a%20spreedsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776957%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383469%22%20target%3D%22_blank%22%3E%40Wast3d7432%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Efollowing%20is%20%22Lost%22%20percentage%3C%2FP%3E%3CP%3E%3D100*SUMIF(%24A%242%3AA10%2C%22Lost%22%2C%24B%242%3A%24B%2410)%2FSUMIF(%24A%242%3AA10%2C%22Won%22%2C%24B%242%3A%24B%2410)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eassumption%20%3A%20column%20A%20has%20Won%2FLost%20information%20and%20and%20B%20has%20amount.%20please%20modify%20the%20column%20range%20as%20needed%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Wast3d7432
Occasional Visitor

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 

 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies