I want to create a formula for SUM and AVERAGE that has a variable number of rows.
Here is the example where the 444 count varies from worksheet to worksheet. I have saved this formula and easy enough to use but want to develop something similar but with many more columns. Worth some time and effort as I evaluate the averages many times a week as they can change daily.
I will send the whole spreadsheet tomorrow and not sure what else I can say. It is a list of hundreds of home sales with 40 or so fields of information. I want to use the sums of 4 or 5 columns (fields) for averages between 2 or 3 fields at a time. For example-divide sum of one field by sum of another add three of those averages together and divide by the number of fields used.