Excel - how to calculate sum of multiple rows into different columns

0 votes

I don't know how to title this. However the question is similar but the output I need is different. Hopefully screen shot will show more clarity.

With formula showing:

with formula showing

What I'm trying to do and hopefully is able to do is, I need to do all those sum's and for the answers to be in the cells shown in total 1 and total 2. For those totals I did it manually, is there a way to do it automatically?

When I do subtotal for instance, I can do each block of sums, but I get the total answer for the whole table and not for each section as shown in the image. When I drag the sum down, I have to delete every other row. Is there a cleaner way?

Without formula showing:

without formula showing

Thank you for any help in advance.

Mar 31, 2022 in Database by Edureka
• 13,690 points
11,056 views

1 answer to this question.

0 votes

The AutoSum button or formula can be found in the Function Library group on the Formulas tab. Take a look at this screenshot:

imagedoc-autosum-2
The AutoSum button or formula can also be found in the Editing group on the Home tab.

In Excel, the AutoSum function has a hotkey/shortcut.
In Excel, the hotkey or shortcut for the AutoSum function is Alt + =.

Select a list of data in Excel, then press the Alt + = keys at the same time to add the sum value to the bottom of the list.

Multiple column autosummation

1. As indicated in the left screen photo, select multiple columns to AutoSum.

2. Press the Alt + = keys at the same time to use the AutoSum function.

Note: The AutoSum function can also be used by going to Formula > AutoSum or Home > AutoSum.image

answered Apr 4, 2022 by Edureka
• 13,690 points

Related Questions In Database

0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

I have a table Emp which has these rows: Emp_cd ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
• 38,000 points
1,603 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,690 points
2,043 views
0 votes
1 answer

How to calculate age (in years) based on Date of Birth and getDate()

Following can be a solution to your ...READ MORE

answered Feb 23, 2022 in Database by Vaani
• 7,070 points
1,573 views
0 votes
1 answer

How to get the "Name Box" name of an Excel cell?

By typing in the Name Box, you ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
5,403 views
0 votes
1 answer
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
1,622 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
642 views
0 votes
1 answer
0 votes
1 answer

How to view the XML form of an Excel file?

Excel is a spreadsheet programme. Click File->Open in ...READ MORE

answered Mar 25, 2022 in Database by Edureka
• 13,690 points
6,165 views
0 votes
1 answer

How to transform multiple tables in one excel sheet to one table with Power BI?

If my prediction is correct- You have a ...READ MORE

answered Apr 4, 2022 in Database by Edureka
• 13,690 points
2,889 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