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

[DaGersh]

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?

 

[Biff]

Post some sample data and include the desired result.

Biff