Google Sheet custom program
Budget: $30 – $250 USD
I want a program in Google Sheets which can sum up numbers people register. If it can be fixed with a simple custom function - great - if not we need to create a program the user can run to create the summed up sheet from the other sheets.
Explanation:
Each sheet will have a unique name e.g. LA for Los Angeles or NY for New York so it will be possible for a program to search for it.
We will have a keyword which each user MUST use so we can recognize it - e.g. VISITORS. Each person will then enter data for "VISITORS 2022" - food or drink - or "VISITORS 2011" - food or drink. So we can find the keyword VISITORS and add the year in the search. Not all sheets will have all years - e.g. LA might have 2015, but not 2020 and NY might not have 2011.
They divide their data into groups for year and category - e.g. 3 under category "Food" and 5 under category "Drink"
We want to sum up "food" for all sheets, "drink" for all sheets and "food" pluss "drink" for all sheets.
A sheet I created which in general explains the task.
https://docs.google.com/spreadsheets/d/1cWuGQsODZ6dlDrHK8-tOwSWP3NxPuO_M0lC6OLa05j0/edit?usp=sharing
Before we can begin, I will need an approval from my client.
Explanation:
Each sheet will have a unique name e.g. LA for Los Angeles or NY for New York so it will be possible for a program to search for it.
We will have a keyword which each user MUST use so we can recognize it - e.g. VISITORS. Each person will then enter data for "VISITORS 2022" - food or drink - or "VISITORS 2011" - food or drink. So we can find the keyword VISITORS and add the year in the search. Not all sheets will have all years - e.g. LA might have 2015, but not 2020 and NY might not have 2011.
They divide their data into groups for year and category - e.g. 3 under category "Food" and 5 under category "Drink"
We want to sum up "food" for all sheets, "drink" for all sheets and "food" pluss "drink" for all sheets.
A sheet I created which in general explains the task.
https://docs.google.com/spreadsheets/d/1cWuGQsODZ6dlDrHK8-tOwSWP3NxPuO_M0lC6OLa05j0/edit?usp=sharing
Before we can begin, I will need an approval from my client.