ExcelBanter - Autofill problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Autofill problem (https://www.excelbanter.com/excel-discussion-misc-queries/120710-re-autofill-problem.html)

Teethless mama

Autofill problem

In B2 =AVERAGE($A2,B$1)
Copy down

"Trout" wrote:

I want to build a matrix of values where each cell is the average of its
column header and row header. For example: I want cell B2 to be the average
of A2 and B1, C2 to be the average of A2 and C1 and B3 to be the average of
A3 and B1. No matter how I enter the equation and try and drag to autofill
Excel doesnt understand what I am trying to do. Any tips?

All times are GMT +1. The time now is 06:26 AM.