» 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))

Screenshot // Count the number of times in particular date a text appear in adjacent column in Microsoft Excel