Date formula Question
Have a summary sheet for my tracking sheet and am looking for a formula that tells me how many of a source/type (01_CNJ) have a date in a specific column.
Current formula (#unparsible):
=COUNTIFS({REFSheet_Source}, "01_CNJ", {REFSheet_Date}, IFERROR(2023(@cell), 0) = 2023)
Best Answer

There's the issue. In your formula you have "CNJ", but the actual data is "CCNJ" (with two C's). Instead of "hard coding" the source criteria, try using a cell reference. This will make the formula more dynamic so you can just dragfill it down for the rest of the rows and it is one less place to accidentally make a typo.
Answers


Hmmm, its giving me 0 but I know 8/9 of the items have a date in the column.

Are you able to provide a screenshot of the data that should be matching along with the updated formula?

that's a screenshot of the variables and the original sheet.
here is formula

There's the issue. In your formula you have "CNJ", but the actual data is "CCNJ" (with two C's). Instead of "hard coding" the source criteria, try using a cell reference. This will make the formula more dynamic so you can just dragfill it down for the rest of the rows and it is one less place to accidentally make a typo.

Oh my goddness! haha thank you!

Help Article Resources
Categories
Check out the Formula Handbook template!