Thread: how do i sum dollars & cents in different columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default how do i sum dollars & cents in different columns
Or, a bit simpler:

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

In article ,
Ron Rosenfeld wrote:

CentsSum: =MOD(SUM(B:B)/100,1)*100
Reply With QuoteReply With Quote