Formula needs to ignore zero values.

Hi Guys,

I have an excel formula which I am using to return the sum of the last five entries in a column which gets data added to it over time. The entries are generated by another formula and are not hard values. The formula I use works perfectly for this but I need it to "ignore" results that are 0 and count the last 5 as being values greater than zero.

Can anybody help?


The formula I am using is: {=SUM(INDEX(B86:B124,LARGE(IF(B86:B124<>"",ROW(B86:B124)-ROW(B86)+1),3)):B124)}


Thanks in advance!

This formula also works but I have the same problem with not counting zero values:

=SUM(OFFSET(B86,COUNTA(B86:B124)-5,0,7))

Thanks Guys,

Your the best both of these options work great!!!

Much Love!

Danny