Using some countif formulas for some basic data analysis. 

Sheet 1 is the data 

Sheet 2 is the overview 

Formula for Sheet 2 – =COUNTIF(‘survey-responses-2024-08-21’!G2:G5000,”18-24″)

I have about 200 survey responses however this is ever growing. I want the results to auto update when I copy and paste in new survey responses. 

When I copy in new responses Sheet 2 is not updating even though I have data rage showing G2:G5000

Whats the reason my results are not updating?

Mac user 

​Using some countif formulas for some basic data analysis.  Sheet 1 is the data Sheet 2 is the overview  Formula for Sheet 2 – =COUNTIF(‘survey-responses-2024-08-21’!G2:G5000,”18-24″) I have about 200 survey responses however this is ever growing. I want the results to auto update when I copy and paste in new survey responses.  When I copy in new responses Sheet 2 is not updating even though I have data rage showing G2:G5000 Whats the reason my results are not updating? Mac user   Read More

​