+ Reply to Thread
Results 1 to 3 of 3

Comparing Counts of Negative vs Positive Data

  1. #1
    Registered User
    Join Date
    11-15-2010
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Comparing Counts of Negative vs Positive Data

    I have two columns, both containing some positive and some negative #s.

    Right now, I have =COUNTIF($V$1:$V$57,"<0") to count the number of times there are negative values, and ">0" to count the positive values for each column.

    I want to compare the two, to get a count of any time that a negative value in column X corresponds to a positive value in column V, and vice versa.

    For example:

    V X
    200 (50)
    431 542
    (43) (56)
    (43) 54
    75 (13)
    and so on.

    So, in this case, I would like a function that gives me a count of the 2 times V is positive and X is negative, and the 1 time that X is positive and V is negative.

    Let me know if you have any other questions - thanks!

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Comparing Counts of Negative vs Positive Data

    For neg V pos X

    =COUNTIFS(A2:A6,"<0",B2:B6,">0")

    For pos V neg X

    =COUNTIFS(A2:A6,">0",B2:B6,"<0")

    The only other question I have is: "Are you still a Jets fan?"

  3. #3
    Registered User
    Join Date
    11-15-2010
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Comparing Counts of Negative vs Positive Data

    Great that worrked perfectly, thanks!

    Of course I still am - only team in the NFL to make it to a conference championship game the past two years. Add in a 2nd year quarterback, 2nd year coach, and some great things are happening for the franchise. Gotta love it.

+ 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