One way:

Assuming that, say $1.23 was entered as

A B
1 1 23

then

Dollars:

=SUM(A1:A100) + INT(SUM(B1:B100)/100)

Cents:

=MOD(SUM(B1:B100),100)

In article ,
"Eric" 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