Reporting Question - Count?

Erin Robertson

 I am trying to create a report that will update a percentage increase average after adding information for a new account - we upload a sheet with this information into one folder for each new account and want to have a report generate this information along with counting the number of instances that all item numbers have been added to previous accounts. I have tried to create a report, but cannot use the =count function on the report to pull the number of times an item has been added to the new account - and if I create a sheet that links to the previously created sheets, it will not pull this information for any future accounts automatically. Thanks so much for your assistance!

Paul Newcome

Are you able to provide some screenshots with mock data for reference?