Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average last 3 in range
I'm having trouble coming up with a formula that only averages the last three
grades in a range. The range is X:BB and the grades are as percentages (e.g., 100%). Note: Some cells in the range may not have data in them, so the formula needs to overlook them and only average the last three grades entered. All help is appreciated. Thanks, -- Mike Mast Special Education Preschool Teacher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AVERAGE a range in a column if another column's range equals a val | Excel Discussion (Misc queries) | |||
Average if....between range | Excel Worksheet Functions | |||
Average of a , < range | Excel Worksheet Functions | |||
Can I sum or average a range with more than 1 condition? | Excel Discussion (Misc queries) | |||
Average Range | Excel Worksheet Functions |