Formula Not Working

CaraBart28

Hello,

I have a formula I am using on multiple reports, to pull data into a dashboard. The formula worked on the first two sheets, however it is not working on the third one and I am not able to figure out what I am doing wrong. I have included a screenshot of the formula, a screenshot of a sheet where the formula works, and the data source. We are trying to count the amount of reports received after the end of the month.

Thank you,

Cara

Report.jpg

Formula Works.jpg

Formula.jpg

Michael Culley

You aren't just copying and pasting the formula into the 3rd sheet right?

The references won't work on a new sheet you need to redo the reference for each sheet.

Paul Newcome

Are you getting an error message or an unexpected number?

CaraBart28

Hi Paul,

Unexpected number, so for instance in the first column it should return a 2 for the report being received later than the date expected, however, it is returning 0.

Thanks!

CaraBart28

Hi Mike,

Correct, I am not copying and pasting, I am redoing each formula.

Thanks!

Paul Newcome

Try replacing the second range with @cell.

=COUNTIFS({Range}, @cell >= DATE(.....))

If that does not work, make sure the column being referenced is in fact set as a date type column and the data in the column is actual dates.

CaraBart28

Morning @Paul Newcome !

So the individual who originally created the sheet did some investigating and identified that he did not have the columns set as date columns as you stated above.

Thanks for all your help!

Paul Newcome

Happy to help. 👍️