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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum last three numbers in a column 7
How to sum the last 7 number in a row? 6
cell address for first value to appear in a range 5
Sum based on criteria in list 4
Transcendental floating point functions are now unfixably brokenon Intel processors 2
SUM ... Numbers, Nulls "", & Div/0 5
Macro works differently on different computers, same version of Ex 6
Sum number range ignoring numbers formatted as text 0

Top