IF [Title]="NoReason" THEN
Though not specified, when the Title is not "NoReason" then the IF statement will return NULL. COUNT of NULL is 0.
This calculated is not giving me the right numbers. Also, the condition I need is when the date is not null, count the ID with the title condition.
I'd suggest you attach a packaged workbook so we can check and make sure our suggested calculated field works.