my problem:
In 1st worksheet I have column with dates from 01/01/2009 up to today. Few next columns are with statistics on daily basis, from monday to friday. Now, in other worksheet I want to make a other statistics provided monthly data dating back until 2009. I have already had first columnt in the 2nd worksheet with the sum of all the daily values, providing one monthly value. Now I would like to do e.g daily average from the monthly values ( I want to divide the sum of daily values by the number of business days in that month). Now my question is:
How can I make a formula that would automatically change the month from the 1st to the 30/31st of the month and then, divide the sum, by COUNTA( from that same group of cells)
COUNTA gets the number of cells which are not empty. In my case saturdays and sundays are empty.
Thanks in advance for any help.
M
Bookmarks