+ Reply to Thread
Results 1 to 5 of 5

Counting Events Formula

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Counting Events Formula

    Please see the attached excel sample.

    We have something like this:
    excel forum question.PNG

    And we want the formula to get the event count on Col D (see first sample values).

    How do we do it?
    Attached Files Attached Files

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: Counting Events Formula

    Try this in D3:

    Please Login or Register  to view this content.
    Enter with Ctrl+Shift+Enter to create an array formula. Then copy to D4, D5 etc. This formula ignores duplicate values.

    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    london
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Counting Events Formula

    Ah.. perfect!
    Thanks a million!

  4. #4
    Registered User
    Join Date
    01-19-2022
    Location
    Alaska, USA
    MS-Off Ver
    2013
    Posts
    14

    Re: Counting Events Formula

    Quote Originally Posted by nicoan View Post
    Please see the attached excel sample.

    We have something like this:
    Attachment 767077

    And we want the formula to get the event count on Col D (see first sample values).

    How do we do it?
    Great. Its working fine.
    I have also find this one,
    In the empty cell, type “ =COUNTIF (range, criteria) .” This formula counts the number of cells in the specified range with text in them

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,398

    Re: Counting Events Formula

    @Victoriaviolet

    You were warned yesterday about pointless posts and ones that fail to address the issue in the thread. This is your FINAL warning. Please desist.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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 Events in Excel
    By msstori in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2016, 08:37 PM
  2. [SOLVED] Counting events by month
    By Mr2006 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-26-2012, 06:04 AM
  3. Counting dated events
    By shellmachine05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2009, 08:05 PM
  4. Counting Events with 3 criteria
    By skep18 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2008, 05:08 PM
  5. Counting events on a given day
    By SER01 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2007, 06:58 PM
  6. [SOLVED] Counting the events
    By osj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2005, 07:06 PM
  7. Counting events between times
    By monty_mm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2005, 12:05 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