how to sum from multiple tables on one table?

Type "=" in your summary sheet then, using the mouse, select the first Sheet/Table's cell then type "+" then select the second sheet's cell, then type "+"... Repeat as required.

Regards,

Hi jaysherrer2,
Take the formulea inclose it in parentheses as in =(B2+Table 2 :: B2+Table 3 :: B2) then divide that by the number of cells in you have in that formula.
In this example there are three =(B2+Table 2 :: B2+Table 3 :: B2)/3.

Or
Use the Average function: =AVERAGE(B2,Table 2 :: B2,Table 3 :: B2)

This will provide you an average not a total.

Hope this helps you.

Sincerely,
RicD

You can easily combine the two functions. You bracket the ROUND "around" the AVERAGE.

Take your two formulas in their basic forms.

=AVERAGE(D1:D4) will average cells D1 to D4

=ROUND(A,2) will round up number A to 2 decimal places.

Now, we want to round up the result of the Average formula so, replace the A in the ROUND with the entire AVERAGE formula above (cut and paste is good here):

=ROUND(AVERAGE(D1:D4),2)

This will first calculate your average and then round it up to 2 decimals.
If you want to round to the nearest whole number use 0

Hope this is what you need.

M.

Hi Moich,
Good formula technique.

Another thing one could do:
This can be applied to any cell when one wants to view all, some, or none of the decimal points.
1. Click the cell with the results. (important)
2. Open Inspector
3. At the top click icon with the 42 in it.
4. Choose Decimals, change setting as desired.

It is important to first click the cell that contains the results otherwise one won't see in Inspector the decimal choice.

Hope this helps as well.

RicD

Hello Ric

CAUTION

What you describe changes ONLY the display.
The contents of the cell continue to be the "decimalized" value.
Only the ROUND() function changes the true stored value.

Yvan KOENIG (from FRANCE jeudi 17 janvier 2008 19:05:16)

Yvan,
Yes as usual you're correct.

My thinking was many times a person wants/needs the behind the scenes decimals for deeper calculations however, they want only to see X places. I should have made my intentions more clear.

Thanks for bring this up, very good call.

Sincerely,

RicD

Hello Ric

I was so often asked about odd results which where simply side effects of the described difference that explaining it is now a reflex.

And today it's a way to have a breath between two attemps upon an infamous script 😉

Yvan KOENIG (from FRANCE jeudi 17 janvier 2008 19:33:43)

We could try and use a formula like:

=ROUND(PI(),2)

and see if rockets can travel in a straight line and flowers grow sideways.

🙂

M.