+ Reply to Thread
Results 1 to 3 of 3

Incremental count across 2 columns while considering a 3rd column

  1. #1
    Registered User
    Join Date
    04-25-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Incremental count across 2 columns while considering a 3rd column

    I have a list that tracking teams, specifically, the game number of the season. I also would like to start the count over every month. I have 3 columns to consider in the formula - 1) the month, 2) the home team, and 3) the visiting team. What I hope to accomplish is something like I have listed below. The # columns are blank in the real file - this is just a small example to illustrate what I'm after. Is something like this even possible? Attached is an excel file with this same data. I greatly appreciate any help and your expertise!

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Incremental count across 2 columns while considering a 3rd column

    See attached workbook for formulas.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    04-25-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Incremental count across 2 columns while considering a 3rd column

    Thank you so very much for your help! It works perfectly and it's very much appreciated!

+ 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] Labeling incremental amounts within each total bar/column
    By Chartastic in forum Excel Charting & Pivots
    Replies: 28
    Last Post: 04-18-2014, 10:51 AM
  2. adding a formula to a column of cells with incremental value (like right corner drag)
    By KAPearson in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2012, 02:24 PM
  3. [SOLVED] incremental Count Page count
    By mohan.r1980 in forum Excel General
    Replies: 3
    Last Post: 05-16-2012, 03:58 AM
  4. Incremental count based on quantity
    By mondo21 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2012, 09:21 AM
  5. Incremental Numbering in a Column w/ Specified Text
    By bgreen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2005, 11:06 AM

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