creating an average?

L

loopiloo

Hi all, I´m brand new here
I am building an excel worksheet that I input 4 different sets of data

Each set has its own page, and there are 12 pages for each month = 48
pages in total.
There is an additional page that totals all this information
Here i need to make an average of one of the sets of data which is the
(TOTAL WIN) this average needs to be divided by how many days the data
has been inputted for.
Here is the formula that i have so far - =SUMA(O7)/A7/*THE AMOUNT OF
DAYS???*
Can any one tell me how this can be done?
Thanks
loopiloo
 
D

David Biddulph

loopiloo said:
Hi all, I´m brand new here
I am building an excel worksheet that I input 4 different sets of data

Each set has its own page, and there are 12 pages for each month = 48
pages in total.
There is an additional page that totals all this information
Here i need to make an average of one of the sets of data which is the
(TOTAL WIN) this average needs to be divided by how many days the data
has been inputted for.
Here is the formula that i have so far - =SUMA(O7)/A7/*THE AMOUNT OF
DAYS???*
Can any one tell me how this can be done?
Click to expand...

Why not use the AVERAGE function?
 
L

legepe

Thanks for the reply, but can you please tell me how to do this.
I am not being lazy not looking in the help menu, it is that i am
working in Spain and the program is in Spanish! and my Spanish is not
the best!
Thanks again
loopiloo
 
Top