Linked numbers CANNOT be Summed up????

Question

Everything can be added up accurately, EXCEPT the linked number from other SHEET of the SAME FILE

The purple block is for the SUM for each row.

The blue block is the linked SUM from another sheet of the same file/workbook.

You can see that "Subt" column shows 0 in the purple box unsuccessfully, whereas "435.39" in bold for "Jan" (typed manually) can be summed up in the purple box. I am using "=SUM(C6:N6)" for the purple box.

I am not sure if linked sums cannot be summed up again, or I just didn't do things correctly!

Please advice.

Thanks

Answer 1

The numbers in blue are left-aligned, suggesting they are text values.

Try

=SUMPRODUCT(--C6:N6)

Answer 2

Thank you for explaining. its always good to know why

Answer 3

Thank u thank u

Yes it does solve the problem and sum up

Answer 4

=SUMPRODUCT(--C6:N6)

If you are wondering about the double negative, the technical term is "double unary".

.

It is one of several technique in Excel to convert text to numbers (described in following article).

.

Double Unary – Convert function output from T/F to 1/0

https://exceljet.net/the-double-negative-in-excel-formulas

A unary operation is an operation with only one operand (input). The double unary (also called a double negative) is an operation used to coerce TRUE FALSE values to ones and zeros in more advanced formulas, especially formulas that work with arrays.