IF THEN & Average.//Ishan

[decentlydoped]

I want to use a formula which can detect the values for the whole column(which gets updated everyday), if that value is true then it will average the values of all those respective other columns having the value. for example: for the whole column C, every cell having value 2 its respective values in column M will get averaged.
Column C having values 1 to 6.
Every number from 1 to 6 in column C has respective data in column M for the month. The sheet gets updated everyday. So, I wish to average the data in column M for all the respective values in column C and should get updated everyday by its own.

 

[arthurbr]

Hi and welcome
first make your table an Excel Structured Table, then use the AVERAGEIF function

 

[Peter_SSs]

Structured table or not, you should still be able to use AVERAGEIF

23 12 19.xlsm
	C										M	N	O	P
1													Column C value	Average
2	5										86		1	30.5
3	2										62		2	38
4	3										85		3	48
5	1										54		4	22
6	2										33		5	86
7	4										22		6	19
8	2										14
9	6										19
10	2										54
11	1										7
12	2										1
13	2										22
14	2										80
15	3										11
16
17
Average

Cell Formulas
Range	Formula
P2:P7	P2	=AVERAGEIF(C2:C1000,O2:O7,M2:M1000)
Dynamic array formulas.