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?

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

Post some sample data and include the desired result.

Biff

"DaGersh" wrote in message
...
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?