SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 731
- Office Version
- 365
- Platform
- Windows
A few days ago, I asked....
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 More Gibberish #EOR, 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, 2
7/2/23, 0
7/2/23, 1
awoohaw gave me the fix here....
Turns out the powers that be now want me to exclude some of the results. So how can I return the same answers awoohaw's beautiful formula returns unless the record that contains #EOB ALSO contains #EOR?
Sheet 2 new result
7/1/23, 1
7/2/23, 0
7/2/23, 1
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 More Gibberish #EOR, 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, 2
7/2/23, 0
7/2/23, 1
awoohaw gave me the fix here....
If it's the right date and IF a cell contains a certain string.....
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...
www.mrexcel.com
Turns out the powers that be now want me to exclude some of the results. So how can I return the same answers awoohaw's beautiful formula returns unless the record that contains #EOB ALSO contains #EOR?
Sheet 2 new result
7/1/23, 1
7/2/23, 0
7/2/23, 1