Hi all,


I'm stuck trying to figure out how to pickout the highest numbers from a list.

Say I have a list of numbers in column A, Starting at A1 and going down up to A500. looking like this:

1
2
3
4
5
0
1
2
3
4
5
6
7
0
1
2
0
0
1
2
3
0

The sequential numbers can go up to any number. Zero is when the list starts over at 1 and is random. I would like to have the highest numbers, the numbers just before the zeros added up and placed in a cell. there could be any number of zeros, and there could be back to back zeros and the sequential numbers could go up to 50, 75 100 or more.

Does this make sense?

thanks for help...
JBF