SOLVED

can't get the formulai want done

Copper 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 (Copper 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.
1 best response

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

View solution in original post