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 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...
3 Replies
- Harun24HRBronze Contributor
You just need COUNTIFS() function.
Screenshot=COUNTIFS(B2:B10,E3,C2:C10,F3)
- SnowMan55Bronze Contributor
For more information and examples, see the attached workbook.
Edit: reattached workbook
- Detlef_LewinSilver Contributor
Use COUNTIFS() or a pivot table.