Go to the Alignment tab in the Format Cells menu then check the Merge cells option and press the OK button. Right click on the selected cells and choose Format Cells. In the next screen shot, the result shows that there was 1 Binder shipment between August 15th and September 15th. Go to the Home tab and click on the small launch icon in the lower right corner of the Alignment section. To get the total units for a different date range, change the product name or start and end dates in the heading section. The result will show a count of the number of times that all the criteria are met.

The 6th argument, “The 5th argument, F5:F18, is the range to check for criteria 3.=COUNTIFS(B5:B18,A2,F5:F18,”>=”&D1,F5:F18,”=”&D1, is the cell with the value for criteria 2 (the Start date), and the operator to use with that value (greater than or equal to) To calculate the number of Pen shipments in the date range, enter this formula in cell F2: The Start date is entered in cell D1, and the End date in cell D2. In this example, there is a drop down list of products in cell A2. The easiest way to find the number of shipments is to use the COUNTIFS function (Excel 2007 and later) and enter the product name, and the start and end dates on the worksheet. We’ll add a start and end date for a date range, and count items in that date range. This screen shot shows a few rows of the list with the order details for this example. For example, how many Pencil shipments went out in September, based on the Ship Date column? If you have a list on your Excel worksheet, and a date in each row, you can use a formula to count items in a date range.

Excel how many rows available in excel