» Counting the Number of Items Sold Every Half Hour
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
- Microsoft Word Version 2002 Inside Out
- Microsoft PowerPoint Version 2002 Step by Step
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Microsoft Office XP Introductory Concepts and Techniques
- The Basics of Finance: Financial Tools for Non Financial Managers
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
