Hello folks!
I am trying to calculate averages across an array of cells for one of six conditions in those cells.
I have five cells (i.e. G11:G15) where each cell can have one of six conditions (e.g. morning, afternoon, ... ) that are being read from another worksheet. In another column I have percentages associated with those five cells (i.e. I11:I15). In a third array of cells (i.e. I19:I24) I need to calculate the average for each of the conditions as they are present across those five cells. For example,
G I
11 morning 11 50%
12 morning 12 75%
13 afternoon 13 100%
14 afternoon 14 50%
15
I
19 average of all of the percents in I when G contains "morning"
20 average of all of the percents in I when G contains "afternoon"
21
22
23
24
etc..
The only other thing I need is to have the calculations in the I19:I24 cells return a blank cell if there are no entries in the others.
I hope this makes sense. Thanks so much in advance.
I am trying to calculate averages across an array of cells for one of six conditions in those cells.
I have five cells (i.e. G11:G15) where each cell can have one of six conditions (e.g. morning, afternoon, ... ) that are being read from another worksheet. In another column I have percentages associated with those five cells (i.e. I11:I15). In a third array of cells (i.e. I19:I24) I need to calculate the average for each of the conditions as they are present across those five cells. For example,
G I
11 morning 11 50%
12 morning 12 75%
13 afternoon 13 100%
14 afternoon 14 50%
15
I
19 average of all of the percents in I when G contains "morning"
20 average of all of the percents in I when G contains "afternoon"
21
22
23
24
etc..
The only other thing I need is to have the calculations in the I19:I24 cells return a blank cell if there are no entries in the others.
I hope this makes sense. Thanks so much in advance.
