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
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

0