I would like to count the number of occasions a report has been logged (column c) in the last 50 days, excluding cases where reports have been marked as "Test" in column E.
I have a working formula for the first half, but I can't seem to get a figure out how to exclude instances where column E is marked as a "test".
=COUNT(FILTER('Report Log'!C:C,DATEDIF('Report Log'!C:C,NOW(),"D")<5000))
Any advice much appreciated!
Aucun commentaire:
Enregistrer un commentaire