+ Reply to Thread
Results 1 to 2 of 2

Adding values in different column / cell

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Adding values in different column / cell

    How do i add multiple rows of currency which the dollar amount is in one cell and the cents in the next cell. Please see example below. Thanks.

    Column A = dollar
    Column B = cents

    Each respective row has a dollar amount - let's say we start with row 1 (i.e. $45 (in column A) and .25 cents (in column B). At row 52, we have the total amount: the dollars in column A and the cents in column B.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    How about

    A52: =INT(SUM(A1:A51)+SUM(B1:B51))
    B52: =SUM(A1:A51)+SUM(B1:B51)-A52


    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1