I hope this finds you well.
What I’m trying to accomplish is I want to be able to search for a specific name in the name column of a table/sheet. If the name does appear in the column, than I want the corresponding value to automatically be added to another entirely different cell in a different table/sheet.
To take it one step further, if the specific name appears multiple times in the column, than I want the sum of all the corresponding values added to the different cell in a different table/sheet.
I’m using Google Sheets as my data source. Sorry if I sound confusing, this is literally my first time using AppSheets.
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |