How to find an Average of SubTotals?

[CB17]

I have a variable list of orders and their completion dates. I want to find the average # of orders completed each day. I used subtotals to count how many were completed each day and now I want to take the average of those. I'm building a macro to do it and I keep getting the wrong output.


Thank you!

 

[Mike Blackman]

Hi,

There is a function in Excel called Average, without knowing a little more about your data layout can't really help apply it. Have a play;

=AVERAGE(A10:F10)