Hello All,
I am having difficulty using a CountIf function to search for a partial invoice number, subject to the Invoice's Due Date and Invoice Status (Past Due or Due Soon).
I have a list of invoice numbers beginning in Row 7 of Column B and their respective Due Dates and Invoice Status in Columns D and F, respectively.
I would like to count the number of results of the search, according to the Date Range (Cells B2 and C2), for invoice numbers containing "123" and that have a "Past Due" Invoice Status, and display the number in cell F5.
Please let me know where I an further clarify any questions. Any assistance is greatly appreciated. Thank you!
SampleInvoice.JPG
Start End
DUE DATE RANGE 11/20/2016 12/20/2016
Invoice # Search: 123 Invoice Status: PAST DUE Search Results: Return the number of results matching the criteria here
Customer Invoice Number Invoice Date Due Date Invoice Amount Invoice Status
CustomerA 123123 10/15/2016 11/14/2016 $5,000.00 PAST DUE
CustomerB 123223 11/26/2016 12/26/2016 $7,500.00 DUE SOON
CustomerB 223224 10/27/2016 11/26/2016 $10,000.00 PAST DUE
CustomerC 123323 11/28/2016 12/28/2016 $50,000.00 DUE SOON
CustomerA 123124 10/29/2016 11/28/2016 $8,000.00 PAST DUE
CustomerA 123125 11/30/2016 12/30/2016 $16,000.00 DUE SOON
Bookmarks