Hi there,
I have a worksheet that pulls through hourly sales for the previous trading week. It stores these values for Monday C4:C25, Tuesday F4:F25 and so on through to Sunday. For clarity, lets call that Table 1.
I want to be able to compute an average of sales taken within a certain...