SUM of linked values

Trym Dahl

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

 

 

 

Atus Bartal

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 

 

Trym Dahl

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

Atus Bartal

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

Trym Dahl

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? 

Atus Bartal

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

 

J. Craig Williams

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

 

Craig