Dear Exceleres,
I would need a excel formula where I can create a score for the scenario as per the picture attached. Repost: i tried to upload a photo but it is not working...can you please help me?
If the criteria applies then it is marked with an "X", if it does not apply it is blank. If the criteria applies than the grade at the specific field under the column A will be selected and calculated in the Score which should be where the arrow is pointing at.
Could you please inform me which formula I should exactly use here?
Repost: I tried to use the formula =IF(F3:F16="X";(SUM(A3:A14))) but it doesnt work...
Thank you.
Best,
forextech
Bookmarks