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


--
loopiloo
------------------------------------------------------------------------
loopiloo's Profile: http://www.excelforum.com/member.php...o&userid=36639
View this thread: http://www.excelforum.com/showthread...hreadid=563919

"loopiloo" wrote in
message ...

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?

Why not use the AVERAGE function?
--
David Biddulph

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


--
legepe
------------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...o&userid=15485
View this thread: http://www.excelforum.com/showthread...hreadid=563919