I have a table that is 6 rows by 30, so 180 cells. I was able to do a lookup so that I now have a column of values and next to it a column which says which cell it belongs to. I can do a countif on the second column to see how many values in each cell. But what I want to do is the average value (from the first column) of each cell (listed in the second column).
How can I do averageif to only average the values belonging to each cell.
A....B
10..6
2....120
6.....3
12....6
so in this case it would only average the 10 and 12 in the first and last rows.
I've made a new column that has 180 rows to correspond to each cell so I'd like to copy down the formula to get the average in each of the 180 cells.
Maureen
How can I do averageif to only average the values belonging to each cell.
A....B
10..6
2....120
6.....3
12....6
so in this case it would only average the 10 and 12 in the first and last rows.
I've made a new column that has 180 rows to correspond to each cell so I'd like to copy down the formula to get the average in each of the 180 cells.
Maureen