sum last 3 numbers greater that 0 in a range

E

eddie151

Joined
Oct 10, 2013
Messages
1
Reaction score
0
hello all

i have the following;

=SUM(LOOKUP(LARGE(IF(ISNUMBER(K5:K57),ROW(K5:K57)),{1,2,3}),ROW(K5:K57),K5:K57))

to return the sum of the last three numbers in a range. however in the range there are zeros and i would like the equation to only include numbers greater than 0. i know i can use ''>'' everywhere i have tried to use it wont work.

thank you i advance

eddie
 
Back
Top