Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average last 3 entries
Can someone help me with some adjustments with this formula that I found in a
search? I need the formula to average the last three entries in a row, which it does...it even does an average if there are less than three.. which is also what I want. But I get an error when there are zero numbers which is what I want to get ride of. I found two other suggestions in my search but I can't get them to work. =AVERAGE(INDEX(A4:H4,LARGE(COLUMN(A:Z)*(ISNUMBER(A 4:H4)),3)):AB4) This one works perfectly except I get an error if there are no entries. I found the follow two formulas that claim to eliminate the problem but don't seem to work: =IF(COUNT(A4:H4)=0,"",AVERAGE(INDEX(A4:H4,LARGE(CO LUMN(A:Z)*(ISNUMBER(A4:H4)),4)):H4)) =IF(COUNT(A4:H4),AVERAGE(INDEX(A4:H4,LARGE(COLUMN( A:Z)*(ISNUMBER(A4:H4)),3)):H4),"NEED DATA") Thanks, -- Mike Mast Special Education Preschool Teacher |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average last 3 entries
=IF(ISERROR(YOUR_FORMULA),"",YOUR_FORMULA)
-- Gary''s Student - gsnu200907 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average last 3 entries
Still having trouble. I get a message that says I've entered too many
arguments. I've tried entering it exactly how you suggested but not having any luck. Here's my formula again {=AVERAGE(INDEX(A10:H10,LARGE(COLUMN(A:H)*(ISNUMBE R(A10:H10)),3)):H10)} Here's the changes I made as you suggested. I'm sure I've done something wrong, but what? {=IF(ISERROR(AVERAGE(INDEX(A10:H10,LARGE(COLUMN(A: H)*(ISNUMBER(A10:H10)),3)):H10),"",AVERAGE(INDEX(A 10:H10,LARGE(COLUMN(A:H)*(ISNUMBER(A10:H10)),3)):H 10)))} -- Mike Mast Special Education Preschool Teacher "Gary''s Student" wrote: =IF(ISERROR(YOUR_FORMULA),"",YOUR_FORMULA) -- Gary''s Student - gsnu200907 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average last 3 entries
It's not real clear what you want to do.
Do you have 0s entered and you want to exclude those 0s from the average? Are the numbers to average *always* poitive numbers? -- Biff Microsoft Excel MVP "Preschool Mike" wrote in message ... Still having trouble. I get a message that says I've entered too many arguments. I've tried entering it exactly how you suggested but not having any luck. Here's my formula again {=AVERAGE(INDEX(A10:H10,LARGE(COLUMN(A:H)*(ISNUMBE R(A10:H10)),3)):H10)} Here's the changes I made as you suggested. I'm sure I've done something wrong, but what? {=IF(ISERROR(AVERAGE(INDEX(A10:H10,LARGE(COLUMN(A: H)*(ISNUMBER(A10:H10)),3)):H10),"",AVERAGE(INDEX(A 10:H10,LARGE(COLUMN(A:H)*(ISNUMBER(A10:H10)),3)):H 10)))} -- Mike Mast Special Education Preschool Teacher "Gary''s Student" wrote: =IF(ISERROR(YOUR_FORMULA),"",YOUR_FORMULA) -- Gary''s Student - gsnu200907 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average last 4 entries in a row. | Excel Discussion (Misc queries) | |||
Average of the last x entries with conditions | Excel Worksheet Functions | |||
average low 10 of last 20 entries | Excel Worksheet Functions | |||
Average of column entries | Excel Discussion (Misc queries) | |||
Any way to calculate an average for more than 30 entries? | Excel Worksheet Functions |