Sum of last 5 values higher than zero

halzyea13

New member
Joined
May 14, 2019
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2013
Hi,

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

Please help.
 

Attachments

  • Book1.xlsx
    58.6 KB · Views: 21
Link to cross post has been added
 
Last edited:
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.
 
Back
Top