+ Reply to Thread
Results 1 to 5 of 5

Using SUMIFS to count the number of inquiries per month based on the date of inquiry

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Oregon
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    21

    Using SUMIFS to count the number of inquiries per month based on the date of inquiry

    I would like to use the Sumifs formula (Excel 2010) to count the number of inquiries per month based on the date of inquiry plus one additional criteria. In the workbook there are two worksheets, the Stats worksheet and the Inquiry worksheet. This is the current formula in the Stats worksheet using Sumproduct.
    =SUMPRODUCT(--(TEXT(Inquiry!$A$3:$A$1000,"MMM-YY")=TEXT($A4,"MMM-YY"))*(ISTEXT(Inquiry!$C$3:$C$1000)))

    The above formulas are in B4:B15 of the Stats worksheet. In column A of the Inquiry worksheet the date of the inquiry is listed. A4:A15 of the Stats worksheet contains the months to be totaled. Column A has been custom formatted for MMM and the date of 1/1/14 was entered in the A4 for January. A5 through A15 lists the remainder of the months of the year. In column C of the Inquiry worksheet the first name of the individual who is calling to inquire is listed. I am using column C to ensure the count is only counting the inquiries with information entered in other than just the date of the call.

    Any assistance anyone can provide will be greatly appreciated. Thank you.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,684

    Re: Using SUMIFS to count the number of inquiries per month based on the date of inquiry

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    MS OFFICE 2013
    Posts
    702

    Re: Using SUMIFS to count the number of inquiries per month based on the date of inquiry

    Sum of said data (SumRange) where the Date(CriteriaRange where dates are logged) is greater than or equal (">="& must be in quotes followed by an amperes symbol) (Date criteria) the start range and is Less than or Equal to ("<="&) (End Date Criteria) End range of dates. Obviously add criteria ranges and criterias if you want to specify say names or inquiry types.

    =SUMIFS(SUMRANGE,DateRange,"<="&Start Date Criteria,"<="&END Date Criteria)
    Should look like this in the data
    =Sumifs(A:A,B:B,">="&D2,B:B,"<="&E2)
    Where A column is my inquiry amounts and B is my dates, Then D2 is Start Date to look from and E2 is End Date to look to.
    -If you think you are done, Start over - ELeGault

  4. #4
    Registered User
    Join Date
    02-13-2013
    Location
    Oregon
    MS-Off Ver
    Excel 2007 & 2013
    Posts
    21

    Re: Using SUMIFS to count the number of inquiries per month based on the date of inquiry

    ELeGault,

    Thank you. Your formula did work. I appreciate your time and response.

  5. #5
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    MS OFFICE 2013
    Posts
    702

    Re: Using SUMIFS to count the number of inquiries per month based on the date of inquiry

    No worries glad it worked for you - Don't forget to mark this 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. Finding last entry of data based on inquiry number and quotation number
    By arbelkasim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-06-2014, 09:27 AM
  2. Count # of inquiries based on year they inquired on - what formula ?
    By Coin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-25-2013, 11:33 AM
  3. Replies: 4
    Last Post: 09-19-2013, 09:19 AM
  4. Replies: 16
    Last Post: 09-06-2010, 05:11 PM
  5. Replies: 3
    Last Post: 09-25-2007, 10:26 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