#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Options
edited 12/09/19

Hello,

How do i create a SUM of linked values from other sheets?

If i break the links and add a numeric value the SUM-formula works.

Best regards

Tags:

• ✭✭✭✭✭✭
Options

Trym,

If you have a formula like this in "SUM: "row:

=SUM(Values1:Values4)    ['Values' is the column name]

then you will get the right value (7 in this case). It doesn't matter that the values in the first 4 rows are linked in from other sheet(s).

I hope this helps.

Atus

• Options

Hi Atus,

Ill send you a printscreen and the formula:

=SUM([Har hanterats checklista för What ToDo]1:[Har hanterats checklista för What ToDo]66)

Still doesent work.

Best regards

• ✭✭✭✭✭✭
Options

Ok, please check if these values linked in are numbers or texts.

• edited 07/14/16
Options

In the sub-sheets, its checkboxes - handled/not handled per row.

At the bottom of this checkbox-column there is a countif-formula:

=COUNTIF([Har hanterats checklista för "What ToDo"]1:[Har hanterats checklista för "What ToDo"]8, 1) + ""

This countif-cell is linked into a master-sheet as seen above with 7/0/0/0 that i try to SUM at the bottom of the column.

Was the an answer to you question?

• ✭✭✭✭✭✭
Options

Yes, thanks.

+ "" is the answer at the end of the formula. I understand that this is the way a checkbox column accepts string/text values, but they just seem to be numbers, and cannot be totalled.

If you would like to make calculations with these values, I would suggest to have another column for the COUNTIF formulae (without + "")

Hope this helps

Atus

• ✭✭✭✭✭✭
Options

You can also convert the text to a number using the VALUE() function.

Craig

This discussion has been closed.