Hi,
I'm looking for a formula to insert into cell AE8 that will calculate the average of the scores in the table based on the two variable criteria entered into cells AE5 and AE6. The table size may vary (number of columns and rows) but the headers will always be unique. So, in the example below the formula finds the 'Header Selection' 8 in Row 3 and then returns the average of the 'Scores' in Col AA that meet the 'Value Selection' of 7.
Any help much appreciated and would prefer a formula solution in this instance, many thanks.
I'm looking for a formula to insert into cell AE8 that will calculate the average of the scores in the table based on the two variable criteria entered into cells AE5 and AE6. The table size may vary (number of columns and rows) but the headers will always be unique. So, in the example below the formula finds the 'Header Selection' 8 in Row 3 and then returns the average of the 'Scores' in Col AA that meet the 'Value Selection' of 7.
Any help much appreciated and would prefer a formula solution in this instance, many thanks.