View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Return only one instance

=SUMIF(Focus!$F$11:$F$900,Focus!$F20,Focus!$P$11:$ P$900)

The above formula will return more than one instance of a value when the
formula is filled down. Is there a way to only show one instance in the
column?