Thread: how do i sum dollars & cents in different columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default how do i sum dollars & cents in different columns
On Sun, 20 Nov 2005 16:04:30 -0700, JE McGimpsey wrote:

Or, a bit simpler:

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

In article ,
Ron Rosenfeld wrote:

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

Duh! Senior moment.


--ron
Reply With QuoteReply With Quote