Results 1 to 4 of 4

using sum if and not equal to??

This is a discussion on using sum if and not equal to?? within the Excel Questions forums, part of the Question Forums category; Hello, I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your ...

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Location
    saint john canada
    Posts
    127

    Default using sum if and not equal to??

    Hello,

    I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your range is not equal to a certain value? I want to sum all values in column B based on the numbers in column A that are all not equal to 5.

    is this possible?

  2. #2
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default Re: using sum if and not equal to??

    Quote Originally Posted by admiral_Tristan
    Hello,

    I'm wondering can you use sumif so that excel sum's a group of values with the conditional that your range is not equal to a certain value? I want to sum all values in column B based on the numbers in column A that are all not equal to 5.

    is this possible?
    =SUMIF(A:A,"<>5",B:B)
    just_jon
    Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

  3. #3
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,722

    Default Re: using sum if and not equal to??

    Hello,

    Do you mean like this?

    =SUMIF(A1:A5,"<>5",B1:B5)

    where
    A1:A5 and B1:B5 = 1 to 5

    Giving an answer of 10.
    -------------------------
    Hope this is helpful.
    -------------------------

    Have been away from the forum for quite a while, but am now back.

  4. #4
    Board Regular
    Join Date
    Dec 2002
    Location
    saint john canada
    Posts
    127

    Default Re: using sum if and not equal to??

    I was missing the " "

    "thanks"


Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com