Software

for your 4 column example above:

SELECT (Avg(Organized)+Avg(Knowledge)+Avg(Voice)+Avg(Materials))/4
FROM Table1;

seems to work.

I get that if I misspell a field name.

It is not quite clear what you have and what you exactly want. Do you have an Access database? Or is it another type? One can indeed use SQL. A good solution is to make a query. Use a summarising option by clicking the ? [sigma] button and use avg or sum on the totals line. In this case the group by option is not needed and both avg and sum can be calculated. If you want to have the overall average in the query use a formula like
AVG: ([Organized]+[Knowledge]+[Voice]+[materials]+....)/14 with 14 fields and select also avg on the totals line. Another formula could be to add all the fields in an expression and to use sum in the totals row. The query would give just two numbers, the overall average and the overall sum. Of course for individual fields a query could be made as well.
However, I would export everything to Excel [just 14 rows] with tools, Office links etc. In Excel it is very easy to calculate in one formula the average of a rectangular area.
Sucess!

This question was closed by the author