Connecting data in different pages and make calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a worksheet that is composed with several pages (from jan-dec). On
this pages there is loads of input data.

My question is how to on a separate page calculate the average on all the
input data. When I have tried this it results in to many parameters, since on
every page the data also is from different check points and thus separate on
the page as well.

Would be very happy for an answer.

Best Regards
/M
 
you looking for the average of the page totals or the average of diffrent
line products ?
 
Im looking for the average of the page totals.

I have already calculated the average on each product by itself, but now I
want to calculate on all the different input data.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Error: Value in Formula of wrong data type 0
Calculated Item in Pivot table 1
Excel - How do I make a cell calculate from another page or tab 1
Rolling Average 2
Formula Error 3
How to calculate average from large dataset in several sheets? 2
Linking to other worksheets 3

Back
Top