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
Thanks
Bookmarks