+ Reply to Thread
Results 1 to 5 of 5

Count if month column AND numerical column equals

  1. #1
    Registered User
    Join Date
    10-22-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Count if month column AND numerical column equals

    I am trying to figure out a formula that will only count how many cells in column B2:B500 equal 31 IF column G has the right month in it.

    So how many times did column B2:B500 equal 31 in October. The date is in column G2:G500 in the 31/12/2016 format.

    The year is not relevant as I have to run this by financial year so I need to make sure that it is not included.

    thanks

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Count if month column AND numerical column equals

    Try this ...

    =SUMPRODUCT((B2:B500=31)*(MONTH(G2:G500)=10))

  3. #3
    Registered User
    Join Date
    10-22-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Count if month column AND numerical column equals

    Thanks that works perfectly

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Count if month column AND numerical column equals

    You're welcome.

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Count if month column AND numerical column equals

    Try below formula.
    =COUNTIFS(B2:B13,31,G2:G13,10)


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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. Replies: 7
    Last Post: 09-14-2016, 09:02 AM
  2. Column chart, one data column of dates: count of month & year
    By brucemc777 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-11-2016, 12:49 PM
  3. Replies: 7
    Last Post: 04-01-2016, 03:27 PM
  4. IF Column E month equals get Column D Value
    By badincite in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-14-2016, 06:49 PM
  5. Count unique occurences in column A if column B equals value
    By butler1012 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2014, 09:15 AM
  6. [SOLVED] Count if column has numerical value
    By ajeffres in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-19-2014, 01:19 PM
  7. [SOLVED] Need to count if Column A contains definded text and Column B equals defined word
    By JBlo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2014, 01:38 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