If it's the right date and IF a cell contains a certain string.....

[SandsB]

Two sheets in my file.

Sheet 1 has a date in column B and the free form text in column A may or may not contain the string #EOB.
Sheet 2 is where I want to count this stuff. Column A is the date and column B is where I need a formula to look at Sheet 1, look at only the rows where the date in column B (could be several hundred records with the same date) is the same as the date in Sheet 2 column A and give me the count of how many of those records have #EOB somewhere in column A. So.... a COUNTIF with a date match of some sort?

Sheet 1 sample
Gibberish, 7/1/23
Gibberish #EOB, 7/1/23
Gibberish, 7/1/23
Gibberish #EOB, 7/1/23
Gibberish, 7/1/23
Gibberish, 7/2/23
Gibberish #EOB, 7/3/23
Gibberish, 7/3/23

Sheet 2 result
7/1/23, 4
7/2/23, 0
7/2/23, 1

 

[awoohaw]

not sure how you got 4 for the first row, try this:

Book1
	A	B	C
1	Sheet 1 sample
2	Gibberish	2007-01-23
3	Gibberish #EOB	2007-01-23
4	Gibberish	2007-01-23
5	Gibberish #EOB	2007-01-23
6	Gibberish	2007-01-23
7	Gibberish	2007-02-23
8	Gibberish #EOB	2007-03-23
9	Gibberish	2007-03-23
10
11	Sheet 2 result
12	2007-01-23	4	2
13	2007-02-23	0	0
14	2007-03-23	1	1
Sheet1

Cell Formulas
Range	Formula
C12:C14	C12	=SUM((ISNUMBER(FIND("#EOB",$A$2:$A$9)))*(A12=$B$2:$B$9))

 

[SandsB]

I got 4 because I'm sloppy. Thank you so much.
Standing on the shoulders of giants