Media of media
It is possible and how do do this:
I have a row with different numbers inside every cell, for exemple:
b3 ,c3,d3,e3, (media in f3) and g3,h3,i3 (media in L3),
It is possible to have the media of f3 and L3 in M3?
Thanks
MacBook Pro (Retina, 15-inch, Mid 2014), OS X Yosemite (10.10.1), Key note version 6.5.2 (2119)
Thank you Yellowbox;
Thats work fine with two culumns, but if you have more then two (three or four) columns for the media?
It is possible to have a media from three or more columns? If yes how?
Thank you!
Obrigado Yellow Box;
Isso funciona bem com duas colunas, mas se você tiver mais de duas (três ou quatro) colunas para a mídia?
É possível ter uma mídia de três ou mais colunas? Sim sim, como?
Obrigado!
Hi GCK,
Is "media" AVERAGE?
or perhaps MEDIAN?
What is your language?
Regards,
Ian.
I am guessing Portuguese,
Estou adivinhando o português,
Regards,
Saudações,
Ian.
Hi GCK,
OK, Italian (Portuguese was a guess).
It is possible to have a media from three or more columns? If yes how?
Yes.
MEDIA(F3;L3)
Include other cells in the formula:
MEDIA(F3;L3;P3;T3)
Regards,
Ian.
If it is an average it would be cell M3 =AVERAGE(F3, L3)
or is it median which would be =MEDIAN(F3, L3)
For just two values, those two have the same answer but not for three or more.
Italian, yes AVERAGE I suppose is for media
Thanks again
Yes Yellowbox. You'e right. Média is Average in English and Moyenne in French (my language).
That's right!!
I have tried something like this but for certainly for my mistake doesn't work
Thank you very much.
Thanks, Marc!
Happy Numbering!
Media of media
