SOLVED

New Contributor

# can't get the formulai want done

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?!

4 Replies
best response confirmed by DeAnSokrat88 (New Contributor)
Solution

# Re: can't get the formulai want done

Try this:
=sumproduct(L10:O10,{4,3,2,1})

# Re: can't get the formulai want done

thank you it worked

# Re: can't get the formulai want done

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?

# Re: can't get the formulai want done

Yes indeed it worked, thank you so much.