Thanks, I gave it a go, changed my named range to my selected data (Q1_Data), made it into a array, and it counts the correct ones.
However, when I apply the filter, it still counts the values, I wanted it not to count when the filter was applied.

Thanks