L
Legacy 287389
Guest
Hi good people!,
The closest I found was this formula:
It does work, but it does not disregard zeros. Usually the zeros will be at the bottom of the array in a column. I need the formula in other words to add the last 5 numbers which are bigger than zero. Any help will be greatly appreciated. Thank you kindly..
EDIT: The array stretches only from ED3:ED14..maybe this will make things less complicated?
The closest I found was this formula:
HTML:
=SUM(INDIRECT("ED"&INDEX(ROW(ED:ED),MAX((ED:ED<>"")*(ROW(ED:ED))))&":ED"&INDEX(ROW(ED:ED),MAX((ED:ED<>"")*(ROW(ED:ED))))-2))
It does work, but it does not disregard zeros. Usually the zeros will be at the bottom of the array in a column. I need the formula in other words to add the last 5 numbers which are bigger than zero. Any help will be greatly appreciated. Thank you kindly..
EDIT: The array stretches only from ED3:ED14..maybe this will make things less complicated?
Last edited by a moderator: