Results 1 to 6 of 6

Trying to add a column of numbers, but ignoring negatives

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2009
    Location
    Essex, England
    MS-Off Ver
    Office 2000 in work, Office 2003 at home
    Posts
    10

    Wink Trying to add a column of numbers, but ignoring negatives

    Hi,

    I'm trying to SUM a column, but it has a negative number in it. I want to sum the column but ignore the negative number.

    I.E.
    5
    46
    12
    -15
    3

    so the total would be 66.

    How is this possible or would i have to use another formula instead of SUM.

    Cheers,

    John
    Last edited by Lord Waste; 04-07-2009 at 06:43 AM.

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