Row and column sum in a single cell

[Jimbolimbo]

Greetings

Was wondering if anybody could help me solve a small problem, the following two:

1) When creating random numbers with RAND formula, it automatically creates it with 3 decimal places, even when I format the cells to use 0, upon summing, it counts in those numbers after the comma: aa,xxx it counts in the xxx's, but I'd only like to use the aa's

2)As shown int he picture, the formula for the total row sum and total column sum in a single cell is not right. The value of cell Q27 equal the sum of Q10:q25 and E27:P27.

Many thankyou's in advance

[shg]

Welcome to the forum.

1) When creating random numbers with RAND formula, it automatically creates it with 3 decimal places, even when I format the cells to use 0, upon summing, it counts in those numbers after the comma: aa,xxx it counts in the xxx's, but I'd only like to use the aa's

Excel generates random numbers as Singles between 0 and 1 (they get converted to Doubles when returned to the sheet), so (1) the only thing before the decimal is a zero, and (2) how you format the number (any number) has no effect on its value.

2)As shown int he picture, the formula for the total row sum and total column sum in a single cell is not right. The value of cell Q27 equal the sum of Q10:q25 and E27:P27.

Pretty hard for us to tell from a picture ...