Is there a way to add currency that is broken into a column for dollars and a
column for cents? How do I format so that if the censt are 00 it won't
default to 0? - Thanks a million!

=sum (A:A) + sum( B:B) / 100
should work for the summation

What do you want to show for cents = 0? You can set up a custom format
to show nearly anything you want (or nothing). If you say what you
want it's easier for us to answer.