Adding Multiple Columns with Different IF Statements

Question

Essentially, I am helping to setup a SharePoint site that another department will for reviewing contracts to make sure they are correct. There are many different choice columns with "Correct" "Incorrect" and "N/A" as options. I need to assign a point value to these columns, and they all add up to 100 points.

Normally I would do this with a simple IF statement. I would like to make the calculation all into one calculated column, but cannot get that to work. Not even sure if it can work.

I would like to avoid having over 40 columns designated just for finding scores, and then one for adding them all together. Is there a way to simplify these two calculated columns into one that also sums them together.

=IF([Column A]="Incorrect"0,3) =IF([Column B]="Incorrect"0,5)

So if Column A is "Correct" it is worth 3 points, but Column B would be worth 5.

I'd like the one "Total Score" column that adds these all together. Is that possible? I feel I'm missing an easy solution here.

Are you saying that you will have Column 1 to 100 and each column will have three possible choices? — SharePointer
– SharePointer, Commented May 25, 2017 at 21:46

ReTech · Accepted Answer · 2017-05-26 07:34:52Z

according to the MSDN documentation you can do the following to do the calculation and condition in one column:

=SUM(IF([Column A]="Incorrect", 0, 3), IF([Column B]="Incorrect", 0, 5), ...)

Also you can use nested if-conditions, which could look like that:

IF([Column A]="Correct",3, IF([Column A]="Incorrect",0, IF([Column A]="N/A",1,0)))

This nested condition will set 3 points for "Correct", 0 Points for "Incorrect and 1 point for "N/A"

I will give this a shot. Positive I tried your first option, but maybe I didn't close my parentheses as I kept getting a syntax error. Looks so much simpler when someone else types it out! Be back on Tuesday to let you know if this solves it. I appreciate the help! — Andrew Fluhr
– Andrew Fluhr, Commented May 26, 2017 at 21:00
This worked, thanks! I've marked your answer as the resolution. Thanks again! — Andrew Fluhr
– Andrew Fluhr, Commented May 30, 2017 at 16:50

Stack Exchange Network

Adding Multiple Columns with Different IF Statements

1 Answer 1

Hot Network Questions

Adding Multiple Columns with Different IF Statements

1 Answer 1

Related

Hot Network Questions