I would like to know if it is possible to automate this formula.
=((AVERAGE(C3:C6,C9:C13,C16:C20,C23:C25,C27,C30:C32)*11)+(AVERAGE(C7,C14,C21,C28)*2))+C34
What I am calculating is the average of Monday-Friday then multiplying the average by the total number of Mon-Fri left in the month. I am also averaging Saturdays then multiplying the average by the total number of Sat. left in the month. Then adding those two results to the sum of the values month to date. The mulitiplier changes as new data is populated.
In column "A" I have the date and in column "B" I have the day of week that corresponds with the date.
Any help would be greatly appreciated.
=((AVERAGE(C3:C6,C9:C13,C16:C20,C23:C25,C27,C30:C32)*11)+(AVERAGE(C7,C14,C21,C28)*2))+C34
What I am calculating is the average of Monday-Friday then multiplying the average by the total number of Mon-Fri left in the month. I am also averaging Saturdays then multiplying the average by the total number of Sat. left in the month. Then adding those two results to the sum of the values month to date. The mulitiplier changes as new data is populated.
In column "A" I have the date and in column "B" I have the day of week that corresponds with the date.
Any help would be greatly appreciated.