Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating sum and average values for specific days only | Excel Discussion (Misc queries) | |||
Calculating Average using a Variable Range | Excel Programming | |||
How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions |