sum formulas!??

[violin]

I am going CRAZY trying to figure out this query!!!
I have 37 lines in which I put mileage amounts...3,4,7,14
etc...for the days of a month.(well, ofcourse I only fill
a portion of these)...at the bottom of the columns...I
want to get the SUM of the miles I've driven...ONLY THING
is...I can't figure out how to get the total mileage into
separate columns??? in other words, the total usually
amounts to a 3 digit number...but I can't get the 10s and
the 100s number to appear in the perspective columns. ANY
HELP WILL BE GREATLYYYY APPRECIATED>>
please email to: (e-mail address removed)

 

[Ken Wright]

Well you certainly have me curious as to why you would want to do so??

Anyway, if you have a normal sum in a single cell, in say B28, then to get the
tens, in any other cell:-

=INT(B28/10)

and the units, again in any other cell

=MOD(B28,10)

If you don't want a single cell with the sum, then put the sum formula in in
place of the B28 reference:-

=INT(SUM(B1:B27)/10)

=MOD(SUM(B1:B27),10)

If you wanted a single cell with those numbers and some text in, then:-

=INT(SUM(B1:B27)/10)&" Tens, and "&MOD(SUM(B1:B27),10)&" Units"

but you lose the ability to calculate with the numbers.