Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
A1, A2, A7 all contain DLX
What I want is for all DLX in A:A to SUM the 3rd columns over. So in this example the SUM of C1,C2,C7. I've been playing with SUMIF but you need to select the exact range if there is a match. TIA, Dennis ==================== |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
On Apr 5, 6:52*pm, (Remove the XX's ) wrote:
A1, A2, A7 all contain DLX What I want is for all DLX in A:A to SUM the 3rd columns over. So in this example the SUM of C1,C2,C7. I've been playing with SUMIF but you need to select the exact range if there is a match. TIA, Dennis ==================== I am not understanding. Perhaps a better explanation or "If desired, send your file to dguillett1 @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
A1, A2, A7 all contain DLX
What I want is for all DLX in A:A to SUM the 3rd columns over. So in this example the SUM of C1,C2,C7. I've been playing with SUMIF but you need to select the exact range if there is a match. Are you saying that this formula does not do what you want? =SUMIF(A:A,"DLX",C:C) Rick Rothstein (MVP - Excel) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
In article , "Rick Rothstein" wrote:
A1, A2, A7 all contain DLX What I want is for all DLX in A:A to SUM the 3rd columns over. So in this example the SUM of C1,C2,C7. I've been playing with SUMIF but you need to select the exact range if there is a match. Are you saying that this formula does not do what you want? =SUMIF(A:A,"DLX",C:C) Rick Rothstein (MVP - Excel) Yes, exactly!! Thanx Rick! Dennis ====================== |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
Are you saying that this formula does not do what you want?
=SUMIF(A:A,"DLX",C:C) Yes, exactly!! Thanx Rick! If that formula does not do what you want, then why are you thanking me (with an exclamation mark)? Tell us then, exactly what does the formula I posted do? Rick Rothstein (MVP - Excel) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
Perhaps you have one or more spaces before or after the DLX in column
A. Try this variation: =SUMIF(A:A,"*DLX*",C:C) The asterisk is a wildcard character, meaning any character. Hope this helps. Pete On Apr 11, 4:06*am, (Remove the XX's ) wrote: In article , "Rick Rothstein" wrote: A1, A2, A7 all contain DLX What I want is for all DLX in A:A to SUM the 3rd columns over. So in this example the SUM of C1,C2,C7. I've been playing with SUMIF but you need to select the exact range if there is a match. Are you saying that this formula does not do what you want? =SUMIF(A:A,"DLX",C:C) Rick Rothstein (MVP - Excel) Yes, exactly!! Thanx Rick! Dennis ====================== |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
In article , "Rick Rothstein" wrote:
Are you saying that this formula does not do what you want? =SUMIF(A:A,"DLX",C:C) Yes, exactly!! Thanx Rick! If that formula does not do what you want, then why are you thanking me (with an exclamation mark)? Tell us then, exactly what does the formula I posted do? Rick Rothstein (MVP - Excel) Rick, it DOES do exactly what I want. I am thanking you because I wasn't getting it on my own and your explanation of the syntax got me on track. So....thank you again....dennis |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
Rick, it DOES do exactly what I want. I am thanking you
because I wasn't getting it on my own and your explanation of the syntax got me on track. So....thank you again. Whoops! A little confusion over wording here. I had asked "Are you saying that this formula does not do what you want?" and you answered "Yes, exactly!!" which I took to mean "yes, it does not do what you want". I think this is my fault because I asked my question in the negative which opened it for how to properly answer it... sorry. Anyway, you are quite welcome... I'm glad your problem has been resolved. Rick Rothstein (MVP - Excel) |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF
You have hit upon one of my pet peeves Rick.
Those unanswerable negative questions!! Lawyer..........did you not commit the crime? I personally would answer "yes" but how would that be interpreted by the jury? Gord On Mon, 11 Apr 2011 12:58:45 -0400, "Rick Rothstein" wrote: Whoops! A little confusion over wording here. I had asked "Are you saying that this formula does not do what you want?" and you answered "Yes, exactly!!" which I took to mean "yes, it does not do what you want". I think this is my fault because I asked my question in the negative which opened it for how to properly answer it... sorry. Anyway, you are quite welcome... I'm glad your problem has been resolved. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
Help with SumIf | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |