countif help

Scott Johnson

Hi Folks

hoping i can get some assistance

I have a large tracker that is tracker COVID isolations and test results.

i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard

I made a Weeknumber helper column, the week number will generate if - Positive is checked and based on the Test Result Date

here is the formula I have written, but isnt returned a count for me

=COUNTIFS({Isolation and Absences Range 66}, [Last Week]@row, {Isolation Tracking Range 2}, =1)

Isolation and Absences Range 66 is the column where the if/weeknumber is generated

Isolation Tracking Range 2 is the Positive column (checkbox)

Paul Newcome

What is in the Weeknumber helper column and what is in the [Last Week] column?

Scott Johnson

Weeknumber helper formula

=IF(Positive@row = 1, WEEKNUMBER([Test Result Date]@row, ""))

Last Week column

=WEEKNUMBER(TODAY(-7)

Paul Newcome

Try applying a filter to the sheet that will only show rows that are checked and where the weeknumber helper column is the appropriate week number.

Scott Johnson

it is working as intended

Paul Newcome

How many rows came up?

Scott Johnson

its no longer working.....

when i try to filter the weeknumber helper column, it doesn't recognize any values

Yet I can see the formula result