CountIf statement driven by spesific date and text criteria
Closed
bobcoozey
TrowaD
- Posts
- 1
- Registration date
- Friday February 24, 2017
- Status
- Member
- Last seen
- February 24, 2017
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- CountIf statement driven by spesific date and text criteria
- Fenix internet l on bank statement - Guide
- How many if statements can you nest in excel - Guide
- Sbi statement - Guide
- If statement with date range - Guide
- How to remove false from if statement ✓ - Forum - Excel
1 reply
TrowaD
Feb 27, 2017 at 11:43 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Feb 27, 2017 at 11:43 AM
Hi Bobcoozey,
When the column B is last name, column c is code and column D is date, then you can use:
=COUNTIFS(B2:B100,E2,C2:C100,F2,D2:D100,G2)
Where E2 is the last name you want to lookup, F2 the code and G2 the date.
I would probably change E2:G2 into dropdownlists to easily change the search criteria.
Best regards,
Trowa
When the column B is last name, column c is code and column D is date, then you can use:
=COUNTIFS(B2:B100,E2,C2:C100,F2,D2:D100,G2)
Where E2 is the last name you want to lookup, F2 the code and G2 the date.
I would probably change E2:G2 into dropdownlists to easily change the search criteria.
Best regards,
Trowa