You’ll virtue please see easy formulation to calculate the sum of values through workforce in an Excel spreadsheet:
=SUMIF(group_range, "group name", sum_range)
Please see instance presentations how you can virtue this formulation in observe.
Instance: Sum through Team in Excel
Think we have now please see dataset that presentations the full issues scored through 15 other basketball avid gamers:
Now think we’d like to search out the sum of the issues scored, grouped through group.
To take action, we will be able to virtue the =UNIQUE() serve as to first build a listing of the original groups. We’ll kind please see formulation into mobile F2:
=UNIQUE(B2:B16)
After we press input, a listing of distinctive group names will probably be displayed:
Upcoming, we will be able to virtue the =SUMIF() serve as to search out the sum of issues scored through avid gamers on each and every group.
We’ll kind in please see formulation into mobile G2:
=SUMIF(B2:B16, F2, C2:C16)
We’ll later book and paste this formulation into the too much cells in column G:
That’s it!
Column F shows each and every of the original groups and column G shows the sum of the issues scored through each and every group.
Backup Assets
How you can Calculate a 5 Quantity Abstract in Excel
How you can Calculate the Cruel and Usual Bypass in Excel
How you can Calculate the Interquartile Dimension (IQR) in Excel
