Average based on certain data

%3CLINGO-SUB%20id%3D%22lingo-sub-1335050%22%20slang%3D%22en-US%22%3EAverage%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335050%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20need%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20make%20an%20average%20based%20on%20certain%20data.%3C%2FP%3E%3CP%3EI%20have%20a%20table%20with%20two%20columns.%20The%20first%20column%20(A)%20contains%20repeating%20numbers.%3C%2FP%3E%3CP%3Ein%20the%20second%20column%20(B)%2C%20numbers%20are%20assigned%20based%20on%20the%20first%20column.%3CBR%20%2F%3Efor%20example%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3EA%20-%20B%3C%2FSTRONG%3E%3CBR%20%2F%3E1%20-%2058%3CBR%20%2F%3E2%20-%2067%3CBR%20%2F%3E3%20-%2080%3CBR%20%2F%3E1%20-%2045%3CBR%20%2F%3E1%20-%2078%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20choose%20number%20one%2C%20it%20must%20make%20an%20average%20from%20numbers%2058%2C%2045%2C%2078...%3C%2FP%3E%3CP%3EIf%20I%20choose%20number%202%2C%20it%20must%20make%20average%20from%20number%20assigned%20to%20number%202%20etc...%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1335050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335057%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635427%22%20target%3D%22_blank%22%3E%40majko98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20AVERAGEIF()%20for%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335067%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335067%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20Mr.%20Baklan.%20But%20please%2C%20could%20you%20type%20an%20example%20for%20me%2C%20please.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335081%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335081%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635427%22%20target%3D%22_blank%22%3E%40majko98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186435i9FDF578696BF5ACA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335099%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335099%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335199%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335199%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20last%20question.%3C%2FP%3E%3CP%3EPlease%20check%20picture%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22example.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186444iF8FED00D63E5BD9C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22example.png%22%20alt%3D%22example.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1335465%22%20slang%3D%22en-US%22%3ERe%3A%20Average%20based%20on%20certain%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635427%22%20target%3D%22_blank%22%3E%40majko98%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fcomparing-values-with-condition%2Fm-p%2F1335220%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fcomparing-values-with-condition%2Fm-p%2F1335220%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello, I need your help.

 

I need to make an average based on certain data.

I have a table with two columns. The first column (A) contains repeating numbers.

in the second column (B), numbers are assigned based on the first column.
for example:


A - B
1 - 58
2 - 67
3 - 80
1 - 45
1 - 78

 

If I choose number one, it must make an average from numbers 58, 45, 78...

If I choose number 2, it must make average from number assigned to number 2 etc...

Thank you!

6 Replies
Highlighted

@majko98 

You may use AVERAGEIF() for that.

Highlighted

@Sergei Baklan Thank you Mr. Baklan. But please, could you type an example for me, please.

Highlighted

@majko98 

That's like this

image.png

Highlighted

@Sergei Baklan Thank you very much!

Highlighted

I have last question.

Please check picture below.

example.png