Help with getting the SUM of multiple columns

Ty Werven

I am trying to figure out the function to get the sum of multiple columns. I also want to be able to apply the function the every row in my sheet. So, when the form dumps a new response it auto finds the sum of all the points in the function.

Here are some screenshots to help with my explanation. Thanks.

bisaacs

Hey @Ty Werven,

Maybe try wrapping each cell in an INT() function? That would convert the text to an integer (assuming it is a number).

Then to convert the formula to a column function by right clicking on the cell the formula is in, then hit "Convert to Column Formula" on the popup menu:

Ty Werven

@bisaacs

Hello.

What would I put in the parenthesis for each column that will possible have points in them? Some columns will have nothing in them since the responses from participants vary from doing many things that get them points to very little. So, I just want to be sure that whatever method used will be able to calculate the sum of all of the columns that include possible points, and i will put them in a sum column with total points if that makes sense? Thanks.

bisaacs

Hey @Ty Werven,

Actually I would wrap each cell reference in the SUM formula with the INT function, so something like this:

=SUM(INT([Preceptor total points]@row), INT([Committee Chair total points]@row), INT(etc.)….

Hope that makes sense!