Countifs formula across sheets

Jeanette Conley

I re-entered the formula and this is how it looks

=COUNTIFS({UBMD Dyads}, [UMBD Dyad]@row, {Date 1}, AND(IFERROR(MONTH({Date 2}, 0) = 11, IFERROR(YEAR({Date 2}, 0) = 2021))

Still coming up as 0

Paul Newcome

Right. You need to use "@cell" in the MONTH and YEAR functions.

Enter this exactly as it is (copy/paste)

=COUNTIFS({UBMD Dyads}, [UMBD Dyad]@row, {Date 1}, AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = 2021))

Jeanette Conley

I entered the formula with the @ row and this is what i get

Paul Newcome

You do not want "@row" and you do not want the curly brackets around those bits. Try copy/pasting my last formula exactly as it is.

Jeanette Conley

I copied and pasted the formula and it is working! Thank you so much for all your help:)

Paul Newcome

Happy to help. 👍️