Forum Discussion
patrickmcginnis
Jul 29, 2025Copper Contributor
Lookup 2 values
Hello! I know what I'm trying to accomplish, and I just can't seem to wrap my head around the function. If I'm looking at a column of months, and then a separate column of say rent payments, I want...
Harun24HR
Jul 30, 2025Bronze Contributor
You just need COUNTIFS() function.
=COUNTIFS(B2:B10,E3,C2:C10,F3)
Screenshot