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.
Bookmarks