how do i sum dollars & cents in different columns

In my account sheet I need to have dollars in the first column and cents in
the second. For my total row I would like to be able to have everything sum
(dollars and cents) and then be displayed as it is above (dollars in the
first column and cents in the second) How in the world is this done??? email
me at Eric@thesolarco.com

=SUM(A1:A10)+INT(SUM(B1:B10))

for the dollars

=SUM(B1:B10)-INT(SUM(B1:B10))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Eric" <Eric@discussions.microsoft.com> wrote in message
news:CC87F07C-72E5-46EC-AEF8-297C54C4CEBA@microsoft.com...
> In my account sheet I need to have dollars in the first column and cents
in
> the second. For my total row I would like to be able to have everything
sum
> (dollars and cents) and then be displayed as it is above (dollars in the
> first column and cents in the second) How in the world is this done???
email
> me at Eric@thesolarco.com

On Sun, 20 Nov 2005 14:16:04 -0800, "Eric" <Eric@discussions.microsoft.com>
wrote:

>In my account sheet I need to have dollars in the first column and cents in
>the second. For my total row I would like to be able to have everything sum
>(dollars and cents) and then be displayed as it is above (dollars in the
>first column and cents in the second) How in the world is this done??? email
>me at Eric@thesolarco.com

Do you want to sum them separately, getting results like

DollarSum: $123
CentsSum: 947¢ (947 cents)

or do you want to sum them together, getting results like:

DollarSum: $132
CentsSum: 47¢ (47 cents)

With the Dollars in ColA and the cents in ColB

For the first option:

DollarSum: =SUM(A:A)
CentsSum: =SUM(B:B)

For the second Option:

DollarSum: =SUM(A:A)+INT(SUM(B:B)/100)
CentsSum: =MOD(SUM(B:B)/100,1)*100



--ron

I need to be able to enter cents as whole numbers (not as 0.12 but as 12)

"Bob Phillips" wrote:

> =SUM(A1:A10)+INT(SUM(B1:B10))
>
> for the dollars
>
> =SUM(B1:B10)-INT(SUM(B1:B10))
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Eric" <Eric@discussions.microsoft.com> wrote in message
> news:CC87F07C-72E5-46EC-AEF8-297C54C4CEBA@microsoft.com...
> > In my account sheet I need to have dollars in the first column and cents
> in
> > the second. For my total row I would like to be able to have everything
> sum
> > (dollars and cents) and then be displayed as it is above (dollars in the
> > first column and cents in the second) How in the world is this done???
> email
> > me at Eric@thesolarco.com
>
>
>

Or, a bit simpler:

=MOD(SUM(B:B),100)

In article <2du1o1h6fcomf9ivl7dh02suiek39rj163@4ax.com>,
Ron Rosenfeld <ronrosenfeld@nospam.org> wrote:

> CentsSum: =MOD(SUM(B:B)/100,1)*100

Dollars
=Sum(A1:A10)+Trunc(Sum(B1:B10)/100)
Cents
=Mod(Sum(B1:B10),100)
--
Regards,
Tom Ogilvy



"Eric" <Eric@discussions.microsoft.com> wrote in message
news:5B354E77-1410-4B90-8728-D0080E301976@microsoft.com...
> I need to be able to enter cents as whole numbers (not as 0.12 but as 12)
>
> "Bob Phillips" wrote:
>
> > =SUM(A1:A10)+INT(SUM(B1:B10))
> >
> > for the dollars
> >
> > =SUM(B1:B10)-INT(SUM(B1:B10))
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Eric" <Eric@discussions.microsoft.com> wrote in message
> > news:CC87F07C-72E5-46EC-AEF8-297C54C4CEBA@microsoft.com...
> > > In my account sheet I need to have dollars in the first column and
cents
> > in
> > > the second. For my total row I would like to be able to have
everything
> > sum
> > > (dollars and cents) and then be displayed as it is above (dollars in
the
> > > first column and cents in the second) How in the world is this done???
> > email
> > > me at Eric@thesolarco.com
> >
> >
> >

On Sun, 20 Nov 2005 16:04:30 -0700, JE McGimpsey <jemcgimpsey@mvps.org> wrote:

>Or, a bit simpler:
>
> =MOD(SUM(B:B),100)
>
>In article <2du1o1h6fcomf9ivl7dh02suiek39rj163@4ax.com>,
> Ron Rosenfeld <ronrosenfeld@nospam.org> wrote:
>
>> CentsSum: =MOD(SUM(B:B)/100,1)*100

Duh! Senior moment.


--ron