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 drag-fill 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 drag-fill 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!