CountIf statement driven by spesific date and text criteria
Closed
bobcoozey
Posts
1
Registration date
Friday February 24, 2017
Status
Member
Last seen
February 24, 2017
-
Feb 24, 2017 at 04:28 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 27, 2017 at 11:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 27, 2017 at 11:43 AM
Related:
- CountIf statement driven by spesific date and text criteria
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement - Guide
- Vba case statement - Guide
- Excel if statement with text - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 27, 2017 at 11:43 AM
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