I know it's an old post but I'm searching for something similar but not exactly this and hoping you can help... I have a spreadseet with a tab "Raw data" of 185 survey repsonses and another tab "Analysis". In my Analyis tab i want to count the data in a certain column of my Raw Data, so my formula is =COUNTIF('Raw data'!G2:G186,"Strongly Disagree"). I want G186 to automatically update based on the number of responses. So if I only have 50 responses, my formula updates to =COUNTIF('Raw data'!G2:G151,"Strongly Disagree"). I can manually enter the response numbers into a cell. How do i do this?