+ Reply to Thread
Results 1 to 4 of 4

Counting fourmula of negative values only

  1. #1
    Registered User
    Join Date
    10-07-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    2

    Counting fourmula of negative values only

    How do i count negative vales only in a column?

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,888

    Re: Counting fourmula of negative values only

    Assume your data is in column A, rows 1:15 =COUNTIF(A1:A15,"<0"). This will not sum the negatives, but will count the number of negative values per your post.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-07-2016
    Location
    Melbourne, Australia
    MS-Off Ver
    2016
    Posts
    2

    Re: Counting fourmula of negative values only

    Thanks for the help, the other thing I need to do is add up those negative values

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Counting fourmula of negative values only

    Just change the word COUNT to SUM

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic fourmula
    By jonespandrew in forum Excel General
    Replies: 1
    Last Post: 07-07-2016, 10:59 AM
  2. about if fourmula
    By tinyau in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2016, 03:15 AM
  3. Excell sheet contain all fourmula
    By sterio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-27-2015, 02:23 PM
  4. [SOLVED] Counting Negative Values in a Range
    By andrewc in forum Excel General
    Replies: 9
    Last Post: 12-14-2012, 08:31 AM
  5. Ignore all negative values when counting in another column.
    By Quagga in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 04:38 AM
  6. Replies: 2
    Last Post: 05-18-2010, 07:46 PM
  7. What Fourmula Would I use and How
    By CERYD in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-10-2006, 03:40 PM

Tags for this Thread

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