Forum Discussion

Copper Contributor

Mar 21, 2022

Solved

Mean on excel

Hi there, I need your help I need to calculate the mean of SOME numbers of a column can I on excel? i' m explaining better, I have in the same column datas that belong to 2 different group I woul...

BI & Data Analysis

excel

Excel on Mac

Formulas and Functions

office 365

HansVogelaar
Mar 21, 2022
DrHoney

Let's say that your values are in D2:D100.

You should have (or create) another column that specifies which group the values belong to. For example in G2:G100 you could have 1 if the cell in column D belongs to one group, and 2 if it belongs to the other group. Of course, you can use other indicators, such as Y and N, or M and F, etc.

The mean of the first group is returned by

=AVERAGEIF(G2:G100, 1, D2:D100)

or

=AVERAGEIF(G2:G100, "Y", D2:D100)

etc., and that of the other group by

=AVERAGEIF(G2:G100, 2, D2:D100)

etc.

HansVogelaar

MVP

Mar 21, 2022

DrHoney

Let's say that your values are in D2:D100.

You should have (or create) another column that specifies which group the values belong to. For example in G2:G100 you could have 1 if the cell in column D belongs to one group, and 2 if it belongs to the other group. Of course, you can use other indicators, such as Y and N, or M and F, etc.

The mean of the first group is returned by

=AVERAGEIF(G2:G100, 1, D2:D100)

=AVERAGEIF(G2:G100, "Y", D2:D100)

etc., and that of the other group by

=AVERAGEIF(G2:G100, 2, D2:D100)

etc.