+ Reply to Thread
Results 1 to 2 of 2

Excel Formula - Add column of numbers but ignore negative numbers

  1. #1
    view for Distribution List members
    Guest

    Excel Formula - Add column of numbers but ignore negative numbers

    Help with a formula please - how do I add a column of numbers but
    exclude/ignore any numbers with a negative value?

    Thanks in advace

  2. #2
    bpeltzer
    Guest

    RE: Excel Formula - Add column of numbers but ignore negative numbers

    If your numbers are in column A, =SUMIF(A:A,">=0",A:A)

    "view for Distribution List members" wrote:

    > Help with a formula please - how do I add a column of numbers but
    > exclude/ignore any numbers with a negative value?
    >
    > Thanks in advace


+ 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