CountIf statement driven by spesific date and text criteria [Closed]

Report
Posts
1
Registration date
Friday February 24, 2017
Status
Member
Last seen
February 24, 2017
-
Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
-
Hello,

Employee Work Code Report

I need to summarize every occurrence in column C
within each of the same dates in column D (1/1-1/31)
and based on a specific code.
Also this logic is driven by employee last name

Example : 100 rows of raw data spanning the range of 1/1-1/31, I need to be able to say:
"on 1/2, Smith entered 'Code : A' [this] many times. "
"On 1/3, Smith entered 'Code : A' this many time"

While your at it, mind picking up dinner too? :)

Any info will be very much appreciated.

1 reply

Posts
2702
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 2, 2021
457
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!