How do I create a Countifs using both "not equal to" and LEFT or RIGHT functions?

[thp510]

I have a list of dates on a single column (column A below) that tell me the start date and the termination date and a list of boy or girl on a single column (column B below). So the data looks like this:

	A	B
1	Jan 2023	Boy
2	Feb 2023	Girl
3	March 2023	Girl
4	Feb 2023	Boy
5	Term March 2023	Boy
6	Term Jan 2023	Boy
7	Feb 2023	Girl

There are hundreds of rows like this. I want to find a countifs function that can Count how many boys or girls there are that are NOT termed. Here's what I tried but it doesn't seem to work.

To count number of boys that are not termed: =COUNTIFS(LEFT(A:A, 4), "<>Term", B:B, "Boy")

Unfortunately this is erroring out. Any idea what I can do instead?

 

[Herakles]

=COUNTIFS(A:A,"Term*",B:B,"Boy")

 

[thp510]

=COUNTIFS(A:A,"Term*",B:B,"Boy")

Hi Herakles. I'm trying to count the number of boys that do not have the word term in front of their date. Would I just then do, =countifs(A:A, "<>Term*", B:B, "Boy")?

 

[Herakles]

Whoops!

=COUNTIFS(A:A,"<>Term*",B:B,"Boy")