I have a Google Sheet with dates in Column C, alphanumeric in Column E, and Employee Names in Column F. I am trying to figure out how to build a query to give me a count for each employee listed in Column F after a specific date, say 07/05/2022. I would like for the formula to be used in the "Count" tab. The link to an example sheet is here Test Area
1
-
"... after a specific date, say 07/05/2022" How many are they ?? Do you need to count how many elements are in the found list or how many are the (unique) employes?– DanieleCommented Aug 11, 2022 at 9:48
Add a comment
|
1 Answer
This is the draggable formula you need:
=if(C2:C="",,COUNTA(filter('BAY 1'!F2:F,'BAY 1'!F2:F=C2,'BAY 1'!C2:C>=A$2)))
link to your modified file
-
This is very close to what I am looking for. I would like to be broken down to show the totals for each employee on the list not just a total of what all employees on the list did.– NateMCommented Aug 15, 2022 at 14:49
-
-
This looks like what I need! I will give it a try in a live environment and see how it pans out. Thanks!– NateMCommented Aug 16, 2022 at 20:12