I'm trying to count the number of cells starting with "ABC", and the first three numbers are odd. And the cells next to them say "Here". The cells will say something like ABC21710.

I don't even know the what formula needs to be outside, and what formula needs to be inside. I can do a COUNTIFS formula, and a SUMPRODUCT formula to find odd numbers when the whole number is odd, but all of the numbers are technically even.... I'm lost. There's an example spreadsheet attached.

Please help

Edit for clarification;
- Starts with "ABC"
- Ends with 5 numbers, all of them are technically ever. I'm looking for the odd numbers, of the first 3 numbers listed. And actually, if there's a way to look at the 6th alphanumeric in, which is all that matters here, then that would work. For example "ABC12310", a formula that would look for the 3, which is the 6th alphanumeric in the example.
- Lists "Here in the neighboring cell.

Attached Files

MsForums.xlsx (8.7 KB, 9 views)