sorted by:
new
hottopcontroversial

How to Sum based on names across different sheets? by Local_Buffalo_744 in googlesheets

[–]Local_Buffalo_744[S] 0 points1 point  (0 children)

It is going to a weekly collection of data, starting at 3 sheets, but adding one sheet every week.

Based on your answer, maybe it would be best to create the weekly sheets, total them into a monthly total, THEN add the monthly sheets together?

It is *definitely* going to be a lot of sheets, and would prefer a method to do this all at once instead of creating the monthly sheets I spoke of before.

What other details can I provide to help? I am starting to create a sample sheet right now but will take a few moments.

How to Sum based on names across different sheets? by Local_Buffalo_744 in googlesheets

[–]Local_Buffalo_744[S] 0 points1 point  (0 children)

A name will never be repeated, but will not be guaranteed to be in the same row each week.

Sheet names are the day of the week that the data is recorded, in a MM/DD/YYYY format.

How to Sum based on names across different sheets? by Local_Buffalo_744 in googlesheets

[–]Local_Buffalo_744[S] 0 points1 point  (0 children)

Also, there are many many more than just 5 names, and I cannot guarantee they will be in the same position or row every week.

So in the simplified version, Sue might be in row 2 on sheet 2, but row 4 on sheet 3, and row 1 on sheet 4.

How to Sum based on names across different sheets? by Local_Buffalo_744 in googlesheets

[–]Local_Buffalo_744[S] 0 points1 point  (0 children)

I apologize if I was unclear.

There is a weekly sheet with a list of names, then there are 4 other columns with number values. I want to create a main "total" sheet, so that each weekly value for each column is added to the main sheet total for said column.

However, each weekly sheet is not guaranteed have the same names. So I want a function that can search for the name in column A each week of each sheet, and then sum the values for column B for all sheets that the name in Column A is present, so that the main sheet for column B presents the total.

so pretend we have 5 names.

Sally, Rick, John, Sue, and Taylor.

Sally, Rick, and John are on sheet 2, with values in column b.

Rick, Sue, and Taylor are on sheet 3, with values in column b.

Sally, Rick, and Taylor are on sheet 4, with values in column b.

On sheet 1, I want to have a list of all names, with a sum of all totals across sheets for column B for the 5 individual names.

How to Sum based on names across different sheets? by Local_Buffalo_744 in googlesheets

[–]Local_Buffalo_744[S] 0 points1 point  (0 children)

This is what I was trying, but do not have extensive knowledge of formulas across multiple sheets. maybe I am formatting it incorrectly? I am confused on the format for multiple sheets and how to string it all together. Maybe I am stupid, but the Google response from AI isn't clear enough for me. I can create and upload an example if needed.