+ Reply to Thread
Results 1 to 2 of 2

how to sumif in excel with a not equal criteria

  1. #1
    Ed
    Guest

    how to sumif in excel with a not equal criteria

    Hi I'm trying to use the sumif function but I want to sum everything in a
    range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
    sum everything that is not equal to apple should return 20. Thank you

  2. #2
    CLR
    Guest

    Re: how to sumif in excel with a not equal criteria

    =SUMIF(A:A,"<>apples",B:B)

    Vaya con Dios,
    Chuck, CABGx3


    "Ed" <Ed@discussions.microsoft.com> wrote in message
    news:9592A741-CA39-4795-B3FB-D104EA9A79A6@microsoft.com...
    > Hi I'm trying to use the sumif function but I want to sum everything in a
    > range that is not equal to one criteria eg apples 10 orange 10 pear 10 ..
    > sum everything that is not equal to apple should return 20. Thank you




+ 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