Forum Discussion

patrickmcginnis's avatar
patrickmcginnis
Copper Contributor
Jul 29, 2025

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 to know (for example), how many LATE payments were in JULY? Or how many were ON TIME in SEPTEMBER. 

 

I can see this working, just can't get the right formula...

 

 

Resources