Forum Discussion
Excel, Formulas and Functions
I am using Microsoft 365 with the latest version of Excel. I have two columns of names of members of my church who have made contributions in years 2019, 2020, and 2021. Some of the folks did not ma...
I think you need a full membership list covering the years in which you have an interest. A lookup will determine whether payment was received for each of the years of interest.
=COUNTIFS(Givers2019,MemberList)This might be expected to give rise to 1 (paid) or 0 (not found). Conditional formatting could be used to pretty up the display of results.