Countif when filtered

Hi

 

Trying to get my countif formula to work when I filter certain cells. At the moment the countif is counting the entire spreadsheet against a criteria which is fine, but when I filter I want the total to reflect the visible cells and obviously once I clear the filter it will go back to the grand total

By: Emma

Leave a Reply

Your email address will not be published. Required fields are marked *