+ Reply to Thread
Results 1 to 7 of 7

Determine whether number of positive numbers exceeds number of negative numbers

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Determine whether number of positive numbers exceeds number of negative numbers

    I need formula help for the below column. What I want is a formula that will tell me overall for the column if the majority of numbers have increased or decreased for the month.

    % Increase or Decrease from Prior MTD (header)

    100.00%
    -25.00%
    -50.00%
    0.00%
    -71.43%
    100.00%
    125.00%
    -33.33%
    0.00%
    -75.00%
    0.00%
    100.00%

    Decreased (this is where I want the formula). I want it to say either "increased" or "decreased" depending on the whether the majority of percentages are negative or positive.

    Thank you in advance for help
    Last edited by Richard Buttrey; 12-04-2012 at 06:23 PM. Reason: Thread title not adequate

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Need formula help

    Take a moment to read the Forum Rules (link at the top of the screen), and then amend your title - it should be descriptive of your problem.

    Pete

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Need formula help

    Hi, and welcome to the forum,

    Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



    Since this is your first post I'll change it for you on this occasion, but please remember for the future.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    12-04-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Determine whether number of positive numbers exceeds number of negative numbers

    Thank you for changing the title for me. I've never participated in forums before so this information helps.

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Determine whether number of positive numbers exceeds number of negative numbers

    Okay, with that out of the way then, you can use COUNTIF to count the number of positive values in a range, like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    and for negative values:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    So, you can put these together like this (say in cell A15):

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    12-04-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Determine whether number of positive numbers exceeds number of negative numbers

    This worked perfect. Thank you!

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Determine whether number of positive numbers exceeds number of negative numbers

    You're welcome - and now for a bit more advice.

    Please mark the thread as Solved if you consider it to be so (click on Thread Tools above your first post).

    Also, you can pass on thanks more directly to any contributor by clicking on the "star" icon in the bottom left corner of any post you have found to be helpful.

    Pete

+ 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