count if to determine the duration in a week

Answers
-
Hi, I am trying to use count if to determine the duration in a week:
- The duration is between 03/04/2023 to 07/04/2023
- the "assigned to is = to team (in my new sheet)
Assigned to is column 3
duration is column 4
start date is column 5
end date is column 6
I want to do it in this table:
- So the week column will be the count of the previous thing. Need to match the name according to the assigned to in sheet 1 and the team in sheet 2 and then in sheet 2, count the duration that sheet 1 have between 03/04/2023 to 07/04/2023 but match the previous condition.
-
Hey @Dianak123
My apologies, I'm struggling to understand exactly what it is you're looking to do.
Is there any way you could provide full screen captures of both sheets (either blocking out sensitive data or using "example" sheets that have test data in them)? It would also be helpful to see some typed out examples of what you want the formula to do.
E.g. are you wanting a COUNT of the number of working days, or a COUNT of the number of rows in the previous sheet that meet your criteria? Or are you looking to return a Date if the Name matches?
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!