using sum if and not equal to??

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: using sum if and not equal to??

  1. #1
    Board Regular
    Join Date
    Dec 2002
    Location
    saint john canada
    Posts
    127
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    5,533
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

      
    I was missing the " "

    "thanks"


User Tag List

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