Array Sum to three decimal places

[x65140]

I have an array in cells BN:CA - - each cell contains 120.12
The array total is in CB - formatted to 3 decimal places

Totaled, the ARRAY shows 1681.680 - - i want it to show 1680.168
but the decimals are overflowing.

Here is the array - - {=SUM(LARGE($BN9:$CA9,ROW(INDIRECT(1&":"&$C$2))))}

I also tried adding a ROUND....,3 to it...but couldn't get that to work either.

ideas?

[dluhut]

Well...BN to CA is 14 columns, and in each column has a value of 120.12.

Thus, mathematically, 120.12 x 14 = 1,681.68.

Why is it that you'd like to show is as 1680.168?

ASSUME if the sum of the cell is 1,685.89, how would you like to show it? 1684.589 or 1680.589?

[x65140]

Because it is a scoring system. BEFORE the decimal place is points for HORSE and RIDER, then AFTER the decimal place is the number of pluses (or bonuses) so I need to keep them separate.

[Pete_UK]

So, the decimal point is not really a decimal point, but some marker to split two distinct numbers?

In that case you will need to add the (integer) parts and the (decimal) parts separately, and then join them together again. It would help to see a sample of your workbook.

Pete

[x65140]

i will treat separately and rework. was looking too closely. thx