Filter inside Countif?

[Smoka]

Hello!

I have a spreadsheet with a GANTT-look-a-like sheet. (mock-version attached).

I can use COUNTIF and get all non-empty cells or cells that contains something. BUT that isn't dynamic, FILTER can do the dynamic part. Like specific dates.
But I can't use COUNTIF(FILTER)? And get the amount of results?

I found something about sumproducts but cant get that to work. Any help?

(The yellow part is where I need help, can probably do the rest if I get that part right)

[AliGW]

Administrative Note:

Is you forum profile showing the version of Excel that you need this to work for? There is no FILTER in Excel 2016 ...

Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

Thanks.

[Smoka]

Now I have updated my profile, I use ms365 v2202 with Filter formula included 🙂

[63falcondude]

The WEEKNUM function will return the week number given a certain date.
You can use the TODAY function as that date to give you the current week number.
Modify the last argument of the WEEKNUM function as needed depending on what day your weeks start on.

Try this in E4
=COUNTIFS(J$1:BI$1,">="&WEEKNUM(TODAY()),J4:BI4,"<>")

[63falcondude]

Better yet, I just noticed that you have actual dates in row 2.

Just use this:
=COUNTIFS(J$2:BI$2,">="&TODAY(),J4:BI4,"<>")