How can I add up the above and give me a total of their classes when the classes and percentage will change all the time
Please have a look at the Excel Spreadsheet attached.
Total & Group Data
-
-
-
Re: Total Up Different Groups Percentage And Present Them In A Table
Like this?
=SUMIF($B$2:$B$8,B12,$E$2:$E$8)
-
Re: Total Up Different Groups Percentage And Present Them In A Table
but it does not group them together? I want to group Class A together and give me the total percentage - Group B together and Group C together
-
Re: Total Different Groups Percentage. Present In Table
this works for me
=SUMPRODUCT((($B$2:$B$8)=B12)*($E$2:$E$8))
it can be further expanded for accomodating Class as well
-
Re: Total Different Groups Percentage. Present In Table
struggle to see the difference between the two answers. In fact struggle to follow the question if my first respondance was wrong.
-
Re: Total Different Groups Percentage. Present In Table
not your mistake Badger
it seems that the question and data are not properly framed....I think the sub-gouping with Class is also reqd but for some reason it is not defined in the example given
your solution works...as always :smile:
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!