Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

# Question:Q:Media of media

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)

Posted on

Question marked as Solved

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.

Posted on

I am guessing Portuguese,

Regards,

Saudações,

Ian.

There’s more to the conversation

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.

Feb 28, 2018 5:35 AM

I am guessing Portuguese,

Regards,

Saudações,

Ian.

Feb 28, 2018 10:36 AM

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!

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?

Feb 28, 2018 10:53 AM

Italian, yes AVERAGE I suppose is for media

Thanks again

Feb 28, 2018 11:00 AM

Question marked as Solved

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.

Mar 1, 2018 3:14 AM

That's right!!

I have tried something like this but for certainly for my mistake doesn't work

Thank you very much.

Mar 1, 2018 3:13 AM

User profile for user: GCK7

Question: Media of media