How to sum column until current row

0 votes

I'm adding some values together using an Excel table. I want to have a running total on a specific column (that is, a sum of all values previous and up to the current row). It's simple to do that with ranges; all I have to do is use a relative address for the current row and an absolute cell address for the range's beginning (using the $ notation).

However, using tables, things get messy - the notation for ranges in tables uses the [[]] syntax. Is there a way to denote a range beginning at the top of the column until the current row?

Dec 19, 2022 in Others by Kithuzzz
• 28,700 points
70 views

1 answer to this question.

0 votes

Use the Header as your starting point:

=SUM(Table1[[#Headers],[Num]]:[@Num])

enter image description here

answered Dec 19, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

How to find the last row in a column using openpyxl normal workbook?

ws.max_row will give you the number of rows ...READ MORE

answered Dec 25, 2022 in Others by narikkadan
• 53,160 points
375 views
0 votes
2 answers

How to get the URL of the current tab in Google Chrome?

Its so simple.... If you want to ...READ MORE

answered Aug 12, 2020 in Others by Steve
• 200 points
1,560 views
0 votes
1 answer

How to add a Header Row to a ListView in Flutter?

Hi@akhtar, You can use ListView.builder method in your ...READ MORE

answered Sep 15, 2020 in Others by MD
• 95,420 points
2,831 views
0 votes
1 answer

How to take a screenshot of a current Activity and then share it?

For me, I captured and then shared ...READ MORE

answered Feb 8, 2022 in Others by Soham
• 9,700 points
100 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
386 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
175 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,940 points
162 views
0 votes
1 answer

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 53,160 points
386 views
0 votes
1 answer

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 53,160 points
213 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP