looks like it can't be done

Looks like this can't be done and I'll have to find another alternative to display the results I want.

Thanks anyway!

Averages...it can be done, but why?

Day 1 | 0

Day 2 | 40-50

Day 3 | 60-70

Day 4 | 10-20

Day 5 | 100+

I have seen this before in elementary artithmetic.

But it may be for a class in statistics, in which case the procedure depends on what sort of average you are trying to find.

Let's stick with arithmetic...if this was for a statistics course, you certainly would be more explicit than just asking for an "average" of a list of intervals.

Or I could be wrong, in which case you need to get back to your text.

In general you take the sum of the means, divide by number of days. That would give you a sort of arithmetic average.

i.e., (0 + 45 + 65 + 15 + 50) / 5

Why you would want to know this is a mystery, and your question does not give enough information to go any further. What sort of average you are looking for, or from where does this problem arise (i.e., context) would help if you want more sophisticated answers.

Thanks for your inqiury.

Bye.