Row and column sum in a single cell

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