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.
Related:
CountIf statement driven by spesific date and text criteria
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.
