Share via

grade summary

Anonymous
2022-01-26T00:53:13+00:00

please what is the formula for summarizing grades

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2022-01-26T01:06:55+00:00

    Hi Princeyemi,

    I don't think this can be done with a single formula.

    An easy way to do this is using Unique, COUNTIF and CONCAT function.

    For instance:

    First, use Unique function to get all the grades under your Grade column:

    Then, use COUNTIF to calculate how many times they appear under Grade Column.

    Finally, use CONCAT to link these values.

    =CONCAT(B2,C2,", ",B3,C3,", ",B4,C4,", ",B5,C5,", ",B6,C6)

    Regards,

    Alex Chen

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-28T22:06:45+00:00

    But please i am a kind of having problem with the "unique" formula

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-01-28T22:03:53+00:00

    Thank you very much

    i really appreciate your kind gestures and answer

    hope meeting you again

    Was this answer helpful?

    0 comments