View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DaGersh DaGersh is offline
external usenet poster
 
Posts: 1
Default 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?