SOLVED

Count people who contributed two yrs in a row

%3CLINGO-SUB%20id%3D%22lingo-sub-2211025%22%20slang%3D%22en-US%22%3ECount%20people%20who%20contributed%20two%20yrs%20in%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2211025%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20need%20to%20count%20the%20number%20of%20people%20who%20donated%20two%20years%20in%20a%20row.%20In%20the%20following%20example%2C%20only%201%20donor%20would%20qualify%20(donor%201001).%20I%20tried%20the%20following%20but%20it%20does%20not%20work%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCOUNTIFS(A1%3AC7%2CB2%3AB7%26lt%3B%26gt%3B%22%22%2CA1%3AC7%2CC2%3AC7%26lt%3B%26gt%3B%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20this%20is%20an%20array%20formula%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Elva_Tanguerre_0-1615816716995.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F263736i62F9319D8F843DBD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Elva_Tanguerre_0-1615816716995.png%22%20alt%3D%22Elva_Tanguerre_0-1615816716995.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2211025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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.

Elva_Tanguerre_0-1615816716995.png

 

 

2 Replies
best response confirmed by Elva_Tanguerre (New Contributor)
Solution
Close!
=COUNTIFS(B2:B7,"<>",C2:C7,"<>")
Hi, thanks! It works, with a tweak to exclude 0 $ amounts (the "-" in my table)

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