I have multiple columns of data filled with numbers. I am using a count if function to count the total amount of numbers that are greater than a specific number. I want the specific criteria number to be input in a different cell, so the countif number updates automatically when the user changes that input.
So I have =COUNTIF(Q2:Q3000,">3"). I want to hange the ">3" to A4 for example, and a4 would be a different cell where someone would input the number 3.
Bookmarks