How to Calculate total in table?

**Reema** · 05-25-2009, 05:30 AM

Hi,

can anyone give me the solution how to calculate total in the table?

I have a table with 4 different columns. Each column has a measurable indicator where the value can range from 1 to 10.

In the last column, I would like the field to calculate the average score for the previous 3 columns in that row.

Is there a way to do this?

Thanks

**JBeaucaire** · 05-25-2009, 11:27 AM

To average the values in A2, B2 & C2, in cell D2 you would use the formula:

=AVERAGE(A2:C2)

Enter that formula in your 4th column adjusting for your actual columns. Then copy that cell down the column and it will adjust itself for each row.

**ConneXionLost** · 05-25-2009, 12:39 PM

Hi Reema,

Seeing as you posted this thread in the "Access Programming" Forum, it raises the question of whether you meant the answer to address the Excel method (as JBeaucaire has provided) or the Access method, being: "Don't store calculated values in a table. Use a query instead."

Hopefully, you'll clarify your requirement.

Cheers,

**JBeaucaire** · 05-25-2009, 07:43 PM

Originally Posted by ConneXionLost

...Seeing as you posted this thread in the "Access Programming" Forum, it raises the question of whether you meant the answer to address the Excel method (as JBeaucaire has provided) or the Access method, being: "Don't store calculated values in a table. Use a query instead."

**blush** ** embarrassment** I didn't even notice that. Sorry about that!