how to sum a repeated val only once and meet a certian criteria?

In Excel, I want to add from an array a 2 condition set of figures, all
numbers above zero and only 'one per order number' so the value is not
repeated, at the same time?

Post some sample data and include the desired result.

Biff

"DaGersh" <[email protected]> wrote in message
news:[email protected]...
> In Excel, I want to add from an array a 2 condition set of figures, all
> numbers above zero and only 'one per order number' so the value is not
> repeated, at the same time?