+ Reply to Thread
Results 1 to 3 of 3

Sumproduct/text/month

  1. #1
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    272

    Sumproduct/text/month

    [ =SUMPRODUCT((TEXT($B$14:$B$1113,"ddd;;;")="Jan")+0) ]
    This formula was originally written to count the instences of days of the week.
    I need to revise it to count the instences of months.
    In this data, April should return 5, and May should return 4.
    Can anyone help with this?
    Thank in advance, Sick

    Tuesday, April 24, 2012
    Tuesday, April 24, 2012
    Wednesday, April 25, 2012
    Thursday, April 26, 2012
    Monday, April 30, 2012
    Friday, May 11, 2012
    Wednesday, May 02, 2012
    Wednesday, May 02, 2012
    Wednesday, May 02, 2012
    Last edited by sick stigma; 07-28-2012 at 03:39 PM.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Sumproduct/text/month

    Just change ddd to mmm.......

    =SUMPRODUCT((TEXT($B$14:$B$1113,"mmm;;;")="Jan")+0)
    Audere est facere

  3. #3
    Forum Contributor
    Join Date
    06-20-2007
    Location
    Buckeye, AZ
    MS-Off Ver
    365
    Posts
    272

    Re: Sumproduct/text/month

    that was too easy! Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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