伯爵文字出现在Microsoft Excel中相邻列在特定日期的次数
-------------------------------------------- A列中的日期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))
屏幕截图//计算特定日期在Microsoft Excel中相邻列中出现文本的次数//images/screenshots/604.jpg [image:https://www.office-skill.site/images/g [文本在Microsoft Excel的相邻列中出现的特定日期的特定次数]]:图像:https://www.office-skill.site/images/f [image,width = 20,height = 1]