Forum Discussion
Countif not updating
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
1 Reply
joshuabradleypp Check formula calculation option is set to Automatic or not. Also check your data type in Column G. Are they text or dates? Can you please share the file via onedrive or google-drive so that we can have a look.
