Rownddown for sum

[Diakarab]

Hello. I am trying to rounddown a sum and can't seem to figure it out. I
need the actual numbers in the cells to have decimal points, but the
total needs to be a whole number. Help : )

 

[Paul]

Hello. I am trying to rounddown a sum and can't seem to figure it out. I
need the actual numbers in the cells to have decimal points, but the
total needs to be a whole number. Help : )

Try something like:
=ROUNDDOWN(SUM(A1:A10),0)

 

[Diakarab]

Thanks, I tried that but it ends up rounding down the total. What I nee
is for the individual amounts to round down before they are totalled
but to still appear in the cells with the decimal points. Any chance o
making that happen? Thanks again