Calculating Average, Count, Min & Max against a range of Values
 

Hi all,

I have a table as follows

Col A Col B Col C
Consumption Average Kcal Energy %
0.62 4824 8.02
0.64 4773 8.15
0.71 4137 8.23
0.685 4366 8.26
0.67 4398 8.34
0.723 4026 8.45
0.701 4111 8.40
0.69 4216 8.50
---- ---- ----
--- ---- ----

I would like to find the following

1. Count of Col A figures for specified ranges, for. e.g. (0.60-0.64); (0.64-0.67), (0.67-0.70), (0.70-0.73)

2.Average of Col B figures against the above-mentioned specified ranges of Col A

3. Minimum and Maximum of Col C figures against the above-mentioned specified ranges of Col A

Thanks in advance.

San