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?

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?

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?

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

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

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