+ Reply to Thread
Results 1 to 7 of 7

Formula for counting occurrences

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    Aurora, CO
    MS-Off Ver
    2010
    Posts
    4

    Formula for counting occurrences

    I need a formula that will count occurrences in a row where the value of an element in the row is less than the value of an element in the column above it. I have tried countif and countifs but couldn't make them do what I need. See attachment (couldn't upload it). I will gladly email an attachment to anyone interested in helping. Thanks for any help you can offer.

  2. #2
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    Re: Formula for counting occurrences

    Click at "Go Advanced" Button.
    Then you'll see a Paperclip at main bar of message window.

    I hope it helps.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marc?lio Lob?o

  3. #3
    Registered User
    Join Date
    09-03-2015
    Location
    Aurora, CO
    MS-Off Ver
    2010
    Posts
    4

    Re: Formula for counting occurrences

    I tried using the Paper Clip, but the file still wouldn't upload. Thanks anyway.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Formula for counting occurrences

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    09-03-2015
    Location
    Aurora, CO
    MS-Off Ver
    2010
    Posts
    4

    Re: Formula for counting occurrences

    I tried that, but after clicking "upload", it just continued to spin, but no file ever appeared. Thanks anyway.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Formula for counting occurrences

    How big is the file, and what is the extension?
    We ONLY need a small, representative sample of your date, not the whole file - just enough to show us what you are working with, and samples of your expected outcome

  7. #7
    Registered User
    Join Date
    09-03-2015
    Location
    Aurora, CO
    MS-Off Ver
    2010
    Posts
    4

    Re: Formula for counting occurrences

    It's just a few lines of a single worksheet xlsx file. I tried attaching a screenshot (.png) to this reply, but that wouldn't upload either

+ 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. Counting Occurrences
    By RiaanDeysel in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2015, 11:52 AM
  2. [SOLVED] Formula for counting the number of occurrences within a range of cells AND Strings help
    By V1gilante in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-14-2014, 07:58 PM
  3. [SOLVED] counting occurrences
    By kri54sub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2013, 01:01 PM
  4. Counting occurrences within a timeframe
    By MitchC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2013, 08:15 PM
  5. Counting occurrences
    By HaydenB in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-30-2010, 04:26 PM
  6. Counting occurrences of two conditions
    By mfernandes in forum Excel General
    Replies: 2
    Last Post: 10-01-2010, 03:19 PM
  7. Counting occurrences of a value within a range
    By amyg in forum Excel General
    Replies: 7
    Last Post: 11-07-2008, 12:16 PM

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