Apr 17 2021 03:50 PM - edited Apr 17 2021 04:11 PM
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?!
Apr 17 2021 05:06 PM
SolutionApr 17 2021 05:12 PM - edited Apr 17 2021 05:58 PM
thank you it worked
Apr 17 2021 06:57 PM
Apr 17 2021 05:06 PM
Solution