Forum Discussion
Show average of cells which display X text.
Hi Please can you help create a formula for the below:.. In column M, what is the formula i would need if i wanted to take an average of column L, based on what text is based in colu...
You could use the AVERAGEIFS() function to accomplish this. Specifically, for your case M2 would look like =averageifs($K$2:$K$7,$D$2:$D$7,D2). You can then drag this cell down for the whole column.
You can look up the averageifs command for more information about how it is working.