I have a list of time sequences related to a billing number. I have used the subtotal function to get a time total for each billing number. I am trying to get an average of time spent on each bill. When I use the average function, the range selected contains all the entries and not just the subtotal entries, so the calculation does not give me the correct answer. All suggestions are be greatly appreciated..