I'm trying to count cells that meet 2 criteria using CountIfs

[BWheezy]

I am trying to use a countifs formula to count the number of entries on my spreadsheet of one sheet and return them to a single cell on another sheet that meet 2 criteria. An associate must be "0-1" year tenure (column C) and "Y" must be in column (column I). Here is my formula and I can't figure out what I'm doing wrong. Appreciate any help.

=COUNTIFS('22624'!A:A,'22624'!I:I="Y",'22624'!A:A,'22624'!C:C = "0-1")

 

[kevin9999]

Perhaps:

=COUNTIFS('22624'!I:I,"Y",'22624'!C:C,"0-1")

 

[BWheezy]

Perhaps:

=COUNTIFS('22624'!I:I,"Y",'22624'!C:C,"0-1")

Thank you so much. I was way overcomplicating it.

 

[kevin9999]

Happy to help & welcome to the Forum