» Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
-------------------------------------------- Dates in column A Text in Column B -------------------------------------------- 03/10/2003 | AAA 03/15/2003 | BBB 03/20/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC 03/25/2003 | AAA 03/30/2003 | BBB 04/04/2003 | CCC Question: Count how many times the text "AAA" appears next to 03/25/2003? Answer: 3 times. Date in cell D1: 03/25/2003 Text in cell D2: AAA The Formula: =SUMPRODUCT ((A1:A12=D1)*(B1:B12=D2))

Book Store:
Recommended Books:
- Accounting Principles, with CD, 6th Edition
- Windows XP Annoyances
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Excel 2002 Simply Visual
- Marketing Management
No comments have been submitted.

