+ Reply to Thread
Results 1 to 5 of 5

Count Occurrence

  1. #1
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Count Occurrence

    i have the following code in my sheet which counts the number of times something is done each day as follows

    Please Login or Register  to view this content.
    i then want to put another if statement in second column which just puts the final figure for that day grouped together into the highlighted cells in the example

    cheers guys and girls
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Count Occurrence

    In C2 and drag down: =IF(A3=A2,"",COUNTIFS(A:A,A2))

  3. #3
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Re: Count Occurrence

    its ok i solved it myself with trial and error
    as below

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Re: Count Occurrence

    but thanks Raphaelp yours also worked just tried it so thanks

  5. #5
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Count Occurrence

    You could use this to replace your formula in B2 and drag it down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. [SOLVED] How to count the order of occurrence of duplicates
    By orehovka in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-28-2023, 11:29 PM
  2. Count to next Occurrence (Zero if next)
    By gra0001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-04-2016, 09:52 PM
  3. Count number of occurrence between dates
    By Wskip49 in forum Excel General
    Replies: 5
    Last Post: 09-14-2016, 03:06 PM
  4. [SOLVED] Program to count a text occurrence
    By GDuffell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 02:58 PM
  5. [SOLVED] count and sum occurrence against a value
    By koshur in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2015, 02:46 AM
  6. [SOLVED] Count Intervals Before Next Occurrence
    By jasonsarea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2012, 05:10 AM
  7. Count occurrence of character within a cell
    By Kelli in forum Excel General
    Replies: 2
    Last Post: 01-18-2006, 10:25 AM

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