Devianey26
New Member
- Joined
- Nov 17, 2019
- Messages
- 1
- Office Version
- 365
- 2021
- Platform
- Windows
I have an excel book with 13 sheets. The first 12 sheets are months (Jan-Dec) and the final sheet is The "Total Sheet" where I add the totals of each name from each sheet. So,
If I have the name, John Doe, in column A3 of sheet "Jan" and again in column A20 of sheet "Mar", I want to "sum" their totals located in column D3 of sheet "Jan" and D20 of sheet "Mar" (because these are the cells where the name appeared within the respective sheets) and add the total of each occurrence into column B2 of the "Total Sheet". I also want to copy the name to column A2 of the "Total Sheet", the first time the name is located. In the "total Sheet" I only want the name once, I don't want the name duplicated.
I can do this with VBA but because I need to use this Book in "Microsoft Teams" I can't use micros. So I want to know if I can do this with an Excel formula.
If I have the name, John Doe, in column A3 of sheet "Jan" and again in column A20 of sheet "Mar", I want to "sum" their totals located in column D3 of sheet "Jan" and D20 of sheet "Mar" (because these are the cells where the name appeared within the respective sheets) and add the total of each occurrence into column B2 of the "Total Sheet". I also want to copy the name to column A2 of the "Total Sheet", the first time the name is located. In the "total Sheet" I only want the name once, I don't want the name duplicated.
I can do this with VBA but because I need to use this Book in "Microsoft Teams" I can't use micros. So I want to know if I can do this with an Excel formula.