Sum of last 5 values higher than zero

[halzyea13]

Hi,

I am trying to sum the last 5 non zero values in row 241. See attached sheet.

Please help.

[Pecoflyer]

Link to cross post has been added

[halzyea13]

Hi,

I also posted this question on another forum with the link https://www.mrexcel.com/forum/excel-...than-zero.html

[p45cal]

Be aware that in the title you asked for: last 5 values higher than zero
and in the body of your message you ask for: last 5 non zero values
It makes a difference to the formula.