» Counting the Number of Items Sold Every Half Hour
Columns A:B contain a list of sold items and their matching sale time. Column C contains a list of times, 30 minutes apart.
We want to count the number of items sold in each 30 minute time period.
To find the number of items sold between 20:00 and 20:30 use the SUMPRODUCT function as shown in the following formula:
|Screenshot // Counting the Number of Items Sold Every Half Hour|