### Tags: average, below, calculate, dataset, example, excel, input, microsoft, msdn, sheet, sheets, software, table, tanks

# How to calculate average from large dataset in several sheets?

On Microsoft » Microsoft Excel

3,703 words with 2 Comments; publish: Wed, 04 Jun 2008 18:42:00 GMT; (30642.97, « »)

I have a table that looks like the example below.

There are several of these tanks with input data on each sheet and there are

12 sheets in the workbook. I want to make a page where I calculate the

average of all the input data, irrespective of which tank the data comes

from. So the average of all the input data. How do I do this?

Tank A.

Date 10 12 13 17 20

Result 2 3 3 4 3

Average 2 3 3 4 3

Bulknr. 106445 106457 106457 106502

Sats. AA AA AA AA

Sign HE HE HE LF

Tank B.

Date 10 12 13 17 20

Result 2 3 3 4 3

Average 2 3 3 4 3

Bulknr. 106445 106457 106457 106502

Sats. AA AA AA AA

Sign HE HE HE LF

*http://excel.todaysummary.com/q_microsoft-excel_239159.html*

All Comments

Leave a comment...

- 2 Comments
- Hi Orf,
If I'm interpreting your problem correctly, a possible solution is as

follows:

Assuming that the "Result" data is located at B3 thru F3 on each sheet

(example is for two sheets):

On the third sheet, on any cell you want, enter "=average(" and select the

two (or more) sheets at once, and enter "B3:F3)"

example: =AVERAGE(Sheet1:Sheet2!B3:F3)

I hope this helps.

Engin

"Orf" <Orf.excel.todaysummary.com.discussions.microsoft.com> wrote in message

news:D777BB42-375C-4437-8BF4-3E3D3D1BD073.excel.todaysummary.com.microsoft.com...

>I have a table that looks like the example below.

> There are several of these tanks with input data on each sheet and there

> are

> 12 sheets in the workbook. I want to make a page where I calculate the

> average of all the input data, irrespective of which tank the data comes

> from. So the average of all the input data. How do I do this?

> Tank A.

> Date 10 12 13 17 20

> Result 2 3 3 4 3

>

> Average 2 3 3 4 3

> Bulknr. 106445 106457 106457 106502

> Sats. AA AA AA AA

> Sign HE HE HE LF

> Tank B.

> Date 10 12 13 17 20

> Result 2 3 3 4 3

>

> Average 2 3 3 4 3

> Bulknr. 106445 106457 106457 106502

> Sats. AA AA AA AA

> Sign HE HE HE LF

>

#1; Wed, 04 Jun 2008 18:44:00 GMT

- Hi Orf,
- That was very helpful
Thank you!

"Engin" wrote:

> Hi Orf,

> If I'm interpreting your problem correctly, a possible solution is as

> follows:

> Assuming that the "Result" data is located at B3 thru F3 on each sheet

> (example is for two sheets):

> On the third sheet, on any cell you want, enter "=average(" and select the

> two (or more) sheets at once, and enter "B3:F3)"

> example: =AVERAGE(Sheet1:Sheet2!B3:F3)

> I hope this helps.

> Engin

> "Orf" <Orf.excel.todaysummary.com.discussions.microsoft.com> wrote in message

> news:D777BB42-375C-4437-8BF4-3E3D3D1BD073.excel.todaysummary.com.microsoft.com...

> >I have a table that looks like the example below.

> >

> > There are several of these tanks with input data on each sheet and there

> > are

> > 12 sheets in the workbook. I want to make a page where I calculate the

> > average of all the input data, irrespective of which tank the data comes

> > from. So the average of all the input data. How do I do this?

> >

> > Tank A.

> > Date 10 12 13 17 20

> > Result 2 3 3 4 3

> >

> >

> >

> > Average 2 3 3 4 3

> > Bulknr. 106445 106457 106457 106502

> > Sats. AA AA AA AA

> > Sign HE HE HE LF

> >

> > Tank B.

> > Date 10 12 13 17 20

> > Result 2 3 3 4 3

> >

> >

> >

> > Average 2 3 3 4 3

> > Bulknr. 106445 106457 106457 106502

> > Sats. AA AA AA AA

> > Sign HE HE HE LF

> >

>

>

#2; Wed, 04 Jun 2008 18:45:00 GMT

- That was very helpful