I want to count the number of occourances of a "Y" in coulumn D .. so i used
a countif and it works great however when i filter another column it still
counts all the "Y".