SOLVED

can't get the formulai want done

%3CLINGO-SUB%20id%3D%22lingo-sub-2277043%22%20slang%3D%22en-US%22%3Ecan't%20get%20the%20formulai%20want%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277043%22%20slang%3D%22en-US%22%3E%3CP%3Efirst%20of%20all%20hi%2C%20and%20my%20problem%20at%20the%20moment%20is%20adding%20multiple%20functions%20in%20the%20same%20cell%20and%20what%20I%20want%20here%20is..%20when%20I%20am%20trying%20to%20put%201%20in%20the%20king%20row%20I%20made%20it%20to%20know%20that%20the%20king%3D4%2C%20sub%20king%3D3%2C%20sub%20kooz%3D2%2C%20and%20kooz%3D1..%20so%20when%20I%20put%20for%20example%201%20in%20the%20king%20row%20in%20the%20points%20columns%20it%20says%204%20and%20that's%20part%20of%20what%20I%20want%20but%20when%20I%20add%201%20in%20another%20column%20let%20us%20say%20sub-king%20(in%20the%20same%20row%20)%20the%20points%20should%20be%20in%20the%20points%20column%207%20right%3F%3F%20but%20that's%20not%20what%20I%20get%20here%20is%20my%20problem%20I%20don't%20know%20how%20or%20what%20the%20formula%20is%20to%20do%20so%20I%20want%20in%20the%20points%20column%20to%20sum%20the%20numbers%20(4.3.2.1)%20that%20concern%20the%204%20status%2C%20anyone%20get%20what%20I%20mean%20%3F%3F!%20any%20help%3F!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture3.PNG%22%20style%3D%22width%3A%20953px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273558iF59550B6E3B2D54F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture3.PNG%22%20alt%3D%22Capture3.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture2.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F273557i416609141CC3D0F9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture2.PNG%22%20alt%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2277043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277280%22%20slang%3D%22en-US%22%3ERe%3A%20can't%20get%20the%20formulai%20want%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277280%22%20slang%3D%22en-US%22%3EYes%20indeed%20it%20worked%2C%20thank%20you%20so%20much.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277083%22%20slang%3D%22en-US%22%3ERe%3A%20can't%20get%20the%20formulai%20want%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277083%22%20slang%3D%22en-US%22%3EI'm%20afraid%20I'm%20not%20able%20to%20reply%20to%20your%20message%20-%20it's%20giving%20me%20errors.%20But%2C%20it%20sounds%20like%20you%20got%20it%20working%20okay%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277066%22%20slang%3D%22en-US%22%3ERe%3A%20can't%20get%20the%20formulai%20want%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277066%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20it%20worked%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2277062%22%20slang%3D%22en-US%22%3ERe%3A%20can't%20get%20the%20formulai%20want%20done%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277062%22%20slang%3D%22en-US%22%3ETry%20this%3A%3CBR%20%2F%3E%3Dsumproduct(L10%3AO10%2C%7B4%2C3%2C2%2C1%7D)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

first of all hi, and my problem at the moment is adding multiple functions in the same cell and what I want here is.. when I am trying to put 1 in the king row I made it to know that the king=4, sub king=3, sub kooz=2, and kooz=1.. so when I put for example 1 in the king row in the points columns it says 4 and that's part of what I want but when I add 1 in another column let us say sub-king (in the same row ) the points should be in the points column 7 right?? but that's not what I get here is my problem I don't know how or what the formula is to do so I want in the points column to sum the numbers (4.3.2.1) that concern the 4 status, anyone get what I mean ??! any help?!

Capture3.PNGCapture2.PNG

 

4 Replies
best response confirmed by DeAnSokrat88 (New Contributor)
Solution
Try this:
=sumproduct(L10:O10,{4,3,2,1})

thank you it worked

I'm afraid I'm not able to reply to your message - it's giving me errors. But, it sounds like you got it working okay?
Yes indeed it worked, thank you so much.