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 in Database by Edureka
• 9,700 points
88 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 by Edureka
• 9,700 points

Related Questions In Database

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 in Database by Edureka
• 9,700 points
31 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 in Database by Vaani
• 5,240 points
38 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 in Database by Edureka
• 8,820 points
111 views
0 votes
1 answer

How can I calculate deciles with a range of 12,000 cells in excel?

1. Enter the following formula in cell ...READ MORE

answered Mar 25 in Database by Edureka
• 8,820 points
54 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 in Database by Edureka
• 8,820 points
56 views
0 votes
1 answer

Remove duplicates within a row

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

answered Mar 15 in Database by Edureka
• 8,820 points
34 views
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 in Database by Edureka
• 9,700 points
59 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 in Database by Edureka
• 9,700 points
33 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP