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

S

San

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top