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 January 16, 2023 - Feb 27, 2017 at 11:43 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 27, 2017 at 11:43 AM
Related:
- CountIf statement driven by spesific date and text criteria
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Fenix internet on bank statement - Guide
- Excel if statement increment by 1 - Guide
- If cell contains multiple text how to add other cell value? ✓ - Excel Forum
- How to re/name a cell if another cell contains X ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
545
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