numbers find average

Hi Olemacr,

Do you mean sum and average for each row and each column?

This approach makes use of the magical properties of Header Rows, Header Columns and Footer Rows. Those cells exclude themselves from formulas to avoid "self-reference" errors.

A table with one Header Row (1), two Header Columns (A and B) and two Footer Rows (8 and 9).

Formula in A2 (and Fill Down to Row 7)

=SUM(2:2)

Formula in B2 (and Fill Down to Row 7)

=AVERAGE(2:2)

Formula in C8 (and Fill Right)

=SUM(C)

Formula in C9 (and Fill Right)

=AVERAGE(C)

With such a table, you can add more data and the formulas will automatically adjust.

Regards,

Ian.

=average(1:1) will average the all cells in row 1

=average(B1:E1) will average cell B1 thru E1 (inclusive)

e.g.:

select cell A4, then type the following to enter the formula to average all cells in row 1:

=AVERAGE(1:1)

These answers are independent of OS or version of Numbers and would work in MS Excel too

W.R.T.:

"Just updated to OS 10.10 and find that to use a spread sheet I must use Numbers."

You can purchase MS Excel for macOS and use that if you like. You can also download, and install, LibreOffice (or other open office suite) for free.

"I should have mentioned it is the average of those same rows I need."

Do you mean you need to calculate the average value in each row where you have already calculated the sum?

That makes no difference to the process.

In one cell, not in the row (eg. row 2) for which you are calculating the sum and the average, enter the formula:

=AVERAGE(2:2)

In a second cell, also not in the row being calculated, enter the formula: =SUM(2:2)

The formulas above the table are in cells B5 and B4 of the table. For the other rows, replace "SUM" or "AVERAGE" with the function name in column A.

Regards,

Barry

I do not understand this information