|
|
| Average
the Last 3 Non-Zero Values |
The
following formula returns the average for the last 3
non-zero
values in B2:B10...
=AVERAGE(IF(ROW(B2:B10)>=LARGE(IF(B2:B10,ROW(B2:B10)),3),IF(B2:B10,B2:B10)))
| Note
that this is an array formula, which needs
to be confirmed with
CONTROL+SHIFT+ENTER for the PC or COMMAND+RETURN for the Mac. |
Based on the sample data, the formula returns 80. Sample
Workbook |
|
|
