Hi, i have an obviously small question but really struggle to solve it:
I need to find an operater (and formula) that will answer if a specific market (here Munich) has a project in a specific CW and if so, than fill in the Capa/Market value.
Is this possible as i don´t have listet all relvant CW´s but a list of Projects which will take place at a specific time and i need the formula to look also between start and enddate and if there is no project planned projekct in i.e. CW 1 than it should also leave the cell empty
You count use the COUNTIFS() Function to do a count on the project and two criteria checking the start and end date
To make it easier I suggest you attach a sample file and also state the version of Excel you're using because there are more advanced functions in 365 and 2021
