how to group Rows and Sum Automatically in Microsoft excel

admin ExcelComments720Read

I am going to learn how to group rows in Microsoft Excel.

as you can see I prepared a little table here with the various specifications.文章源自LuckYou.ORG-https://luckyou.org/122.html

and I have specific entries for each specification.文章源自LuckYou.ORG-https://luckyou.org/122.html

and now I basically want to group the rows by “bearing”, “didget circuit breaker” , “motor protective circuit breaker” and “control transformer”.文章源自LuckYou.ORG-https://luckyou.org/122.html

So select rows we want to group, and make sure that the title row be included.文章源自LuckYou.ORG-https://luckyou.org/122.html

how to group Rows and Sum Automatically in Microsoft excel文章源自LuckYou.ORG-https://luckyou.org/122.html

Then go to “Data” tab, “outline” section, then click subtotal.文章源自LuckYou.ORG-https://luckyou.org/122.html

so whenever meet the same “specification” value, Excel knows that there should be created another group文章源自LuckYou.ORG-https://luckyou.org/122.html

and the cool thing is that we can nowalso use a function like the sum function文章源自LuckYou.ORG-https://luckyou.org/122.html

which basically means that Microsoft文章源自LuckYou.ORG-https://luckyou.org/122.html

EXCEL will sum up all the values for bearing文章源自LuckYou.ORG-https://luckyou.org/122.html

so these totals that we calculated here manually will be done everything automatically

and in this field here

where it says “add subtotal to”

we simply have to select which columns should be calculated, here we select “quantity” and “price”,

then make sure that this summary below data is checked.

how to group Rows and Sum Automatically in Microsoft excel

and now when you click on OK

you can see that Excel automatically calculated the sub totals

but also integrated the groups.

and that's it

 
匿名

Comment

Anonymous

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

Decide