Example as requested.

A1 = apple B1 = 4 C1 formula = 18
A2 = pear B2 = 7 C2 formula = 14
A3 = orange B3 = 2 C3 formula = 2
A4 = grape B4 = 15 C4 formula = 15
A5 = pear B5 = 6 C5 formula = (returns
blank)
A6 = strawberry B6 = 3 C6 formula = 3
A7 = apple B7 = 14 C7 formula = (returns
blank)
A8 = banana B8 = 5 C8 formula = 5
A9 = pear B9 = 1 C9 formula = (returns
blank)
A10 = gooseberry B10 = 6 C10 formula = 6

The above example will only display the result for the pear and apple once.

Is this possible with a formula.

Pat


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