Tip Printed from ExcelTip.com
Count the number of times in particular date a text appear in adjacent column in Microsoft Excel


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