I have a cell with data that is named total with data in another cell and I need this data in this cell to move to another cell with a formula

Question

I have a cell with data that is named total with data in another cell and I need this data in this cell to move to another cell with a formula

Jackie SOARES 0

Cell name TOTAL - Values are in cell j40 and I need to move it to cell k34. Can this be done for all cells that have a name called TOTAL.

Jackie SOARES 0 Reputation points

2026-10-01T10:04:50.13+00:00

Total cell can appear in different cells how can I add the formula to recognise data in this cell to be moved to another cell
Barry Schwarz 6,191 Reputation points

2026-10-01T14:51:32.4766667+00:00

What does it mean for multiple cells to be named TOTAL?

3 answers

Your answer

Jackie SOARES 0 Reputation points

2026-10-01T10:04:50.13+00:00

Total cell can appear in different cells how can I add the formula to recognise data in this cell to be moved to another cell
Barry Schwarz 6,191 Reputation points

2026-10-01T14:51:32.4766667+00:00

What does it mean for multiple cells to be named TOTAL?

Answer 1

If all you want to do is collect the values in the Amount column that correspond to the text "Total" in the Charge column, enter this formula in D2. It will generate an array of total values at the top of column D.

=FILTER(C:C,B:B="Total")

If you want the total to appear to the right of the first line in each grouping, then enter the following in D2:

=IFS(A2="","",A2=A1,"",TRUE,LET(t,MATCH("Total",B2:B$99,0),INDEX(C2:C$99,t,1)))

Change the final row number ($99) twice to match your data and copy the cell down column D to the end of your data.

The first two tests determine if this is the row to display the total in. If yes, then find the total row and display its value here.

Otherwise, you need to provide a much more detailed description of what data you want to collect and where you want the collection stored.

Answer 2

Julie Huynh 3,770 Independent Advisor

Dear @Jackie SOARES,

Good day! Welcome to Microsoft Q&A forum!

To better understand your scenario, could you please clarify:

Is TOTAL a cell label that appears in your worksheet, or is it a named range created in Excel?
Are you looking to display the value from the TOTAL cell in another cell, or do you want to move the value from one location to another?
Could you provide a small example of your worksheet layout, including where the TOTAL cell is located and where you would like the value to appear? To make sure I understand your requirement correctly, I tested a scenario where a cell contains the label "TOTAL" and an adjacent cell contains the value. I then used a formula to automatically return that value in another cell, even if the TOTAL row changes location within the worksheet.

User's image

Could you help clarify if this is the type of behavior you're looking for?

If you’re able to share a bit more about your situation, I might be able to suggest some helpful next steps.

Kindly let me know when there are updates or if you need further assistance. Any updates you’re able to share would be really helpful. I appreciate your time and look forward to hearing how things are going!

Thank you for your time and patience.

Jackie SOARES 0 Reputation points

2026-10-01T12:35:39.5733333+00:00

image below
Jackie SOARES 0 Reputation points

2026-10-01T12:36:12.4666667+00:00

image below
Julie Huynh 3,770 Reputation points Independent Advisor

2026-10-01T14:06:24.2166667+00:00
Dear @Jackie SOARES,

Thank you for the additional information.

Based on the screenshot, it appears that you would like to display the amount from each TOTAL row in another cell while leaving the original TOTAL value unchanged.

As a test, if there is only one TOTAL entry in the section you're working with, you could try a formula similar to:

=XLOOKUP("TOTAL",B:B,C:C)

where:

B:B is the column containing the text TOTAL

C:C is the column containing the corresponding amount

This would return the value associated with the row labeled TOTAL.

If there are multiple TOTAL rows in the worksheet, as shown in your screenshot, could you please clarify how each highlighted cell relates to its corresponding TOTAL row? For example, is the highlighted cell always a fixed number of rows above the TOTAL row? This will help determine the most appropriate formula for your scenario.

I look forward to your update.

Thank you for your patience.
Julie Huynh 3,770 Reputation points Independent Advisor

2026-10-02T14:26:03.2+00:00

Dear @Jackie SOARES,

Good day! I hope everything is going well on your end.

It’s been a little while, so I just wanted to follow up and see how things are progressing with your concern. If you've run into any challenges or if there's anything further that I can help with, please don’t hesitate to let me know. Any updates you’re able to share would be greatly appreciated.

Thanks again for your time and attention! I look forward to hearing from you.

Answer 3

Jackie SOARES 0

Can a Cell with a particular name eg TOTAL be moved to another cell recognising the value from that cell location to another cell

0 comments