Counting the Number of Items Sold Every Half Hour

CATEGORY - Counting VERSION - All Microsoft Excel Versions

Problem:

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.

Solution:

To find the number of items sold between 20:00 and 20:30 use the SUMPRODUCT function as shown in the following formula:
=SUMPRODUCT(($B$2:$B$5=C2))
Screenshot // Counting the Number of Items Sold Every Half Hour
Counting the Number of Items Sold Every Half Hour

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.