Date formula Question

munoz_rita

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)

Paul Newcome

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.

Paul Newcome

Try replacing the first 2023 with YEAR.

munoz_rita

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

Paul Newcome

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

munoz_rita

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

here is formula

Paul Newcome

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.

munoz_rita

Oh my goddness! haha thank you!

Paul Newcome

Happy to help. 👍️