Return only one instance

[Pat]

=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?

 

[Bob Phillips]

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]

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]

That has only confused me. Where do the numbers in B1 come from, how do you
get those results in C, and what has this got to do with the formula you
last showed (which looks in column F)?

--

HTH

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

 

[Pat]

Sorry Bob I should have given you the formula for colC

=SUMIF(Focus!$A$1:$A$10,Focus!$A1,Focus!$B$1:$B$10)

The above is filled down from C1:C10
Please ignore my original post as I have given you an example as requested.

Pat