Count people who contributed two yrs in a row

[Elva_Tanguerre]

Hello, I need to count the number of people who donated two years in a row. In the following example, only 1 donor would qualify (donor 1001). I tried the following but it does not work:

=COUNTIFS(A1:C7,B2:B7<>"",A1:C7,C2:C7<>"")

I guess this is an array formula

Thanks.

[#2 · Accepted solution]

Close!
=COUNTIFS(B2:B7,"<>",C2:C7,"<>")

[#3]

Hi, thanks! It works, with a tweak to exclude 0 $ amounts (the "-" in my table)

=COUNTIFS(B2:B7,">0",C2:C7,">0")