samedi 28 février 2015

Count cells in column C, excluding instances where Column E contains specific text

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