0

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?
    – Daniele
    Aug 11, 2022 at 9:48

1 Answer 1

0

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

counta

link to your modified file

3
  • 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.
    – NateM
    Aug 15, 2022 at 14:49
  • try my file now
    – Daniele
    Aug 15, 2022 at 22:08
  • This looks like what I need! I will give it a try in a live environment and see how it pans out. Thanks!
    – NateM
    Aug 16, 2022 at 20:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.