I need a Google Sheets Formula
Budget: $30 – $250 USD
I have a Google Sheet with many tabs. The first tab is labeled 'Roster' and the first column in the Roster tab contains a list of persons' names (first last). The second tab is labeled ‘Summary’ and it needs to summarize the sums of specific cells in subsequent tabs. All of the remaining tabs are named with a person's name (first last) which is the same as the names in the Roster tab. Each of the named tabs has two integers in Column 1 at A1, & A2
I want the summary tab to provide two sums of all the values in each of the two cells across all of the named tabs, using the INDIRECT function in the SUM formula, to pull the tab names from the Roster tab. The goal is to avoid having to type all the tab names in the formulas. Can you show me the formula that should go in cells A1 & A2, in the summary tab, to get the two sums?
Below is a link to an example spreadsheet with the tab sums in the summary tab created by listing each tab name. The goal is to extract the tab names from the Roster tab, so I don’t have to type all the names in. Also, if I add a new named tab, I should be able to just add that new tab name to the Roster tab list, and the summary sums will automatically update to include the new tab in the sums.
Tab Name Test: https://docs.google.com/spreadsheets/d/15-6DYaQW5a2LbYl3xzaoXghR8S052Qr_Yh2-NJkoh1U/edit#gid=1483173146
Finally, is there a way to auto-extract the tab names after the Roster & Summary tabs in the sum formulas, so I don’t need to create the Roster tab?
I want the summary tab to provide two sums of all the values in each of the two cells across all of the named tabs, using the INDIRECT function in the SUM formula, to pull the tab names from the Roster tab. The goal is to avoid having to type all the tab names in the formulas. Can you show me the formula that should go in cells A1 & A2, in the summary tab, to get the two sums?
Below is a link to an example spreadsheet with the tab sums in the summary tab created by listing each tab name. The goal is to extract the tab names from the Roster tab, so I don’t have to type all the names in. Also, if I add a new named tab, I should be able to just add that new tab name to the Roster tab list, and the summary sums will automatically update to include the new tab in the sums.
Tab Name Test: https://docs.google.com/spreadsheets/d/15-6DYaQW5a2LbYl3xzaoXghR8S052Qr_Yh2-NJkoh1U/edit#gid=1483173146
Finally, is there a way to auto-extract the tab names after the Roster & Summary tabs in the sum formulas, so I don’t need to create the Roster tab?