+ Reply to Thread
Results 1 to 2 of 2

Desire Sum to add visible figures rather than underlying decimals

  1. #1
    Jerry
    Guest

    Desire Sum to add visible figures rather than underlying decimals

    I have a column of decimals which, through formating, I ask that only the
    whole number be visible. The "Sum" function is adding the underlying
    decimals rather than the visible whole numbers. ie; 2.4 + 2.4 = 4.8 (rounded
    to 5) however I would like 2.4 (rounded to 2) + 2.4 (rounded to 2) to equal
    4. How do I make that happen?
    Thanks for any input
    --
    Jerry

  2. #2
    Forum Contributor
    Join Date
    01-18-2005
    Location
    Auckland New Zealand
    MS-Off Ver
    Office Professional 2007
    Posts
    295
    =sum(int(your-range)), entered as array formula, ie use Ctrl-Shift-Enter

    Regards
    Mike

+ 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