That doesn't return one instance, it returns a sum based upon a condition.

Explain what you want to do with data examples.

--

HTH

RP
(remove nothere from the email address if mailing direct)


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