Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return lowest quantity | Excel Worksheet Functions | |||
RETURN intersecting value with known horizotal & vertical?? | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Return the smallest value | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions |