Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
SUMIF problem
I have a column that contains the following text cells:
abc - 123 abc - 455 abc - 333 zzzzsyt wwtrtzz I just want to sum up the values corresponding to any cell that has an "abc - " in it. How do I do this? I've tried: =SUMIF(range,"*abc*",range) but it doesn't work. Please help! |
#2
|
|||
|
|||
This works for me:
=SUMIF(A:A,"*abc*",B:B) where the values to be summed are in a separate column. Are you trying to extract the values from the text cells? In article , "Nadia" wrote: I have a column that contains the following text cells: abc - 123 abc - 455 abc - 333 zzzzsyt wwtrtzz I just want to sum up the values corresponding to any cell that has an "abc - " in it. How do I do this? I've tried: =SUMIF(range,"*abc*",range) but it doesn't work. |
#3
|
|||
|
|||
Aha! The problem was that the data range I was specifying
didn't reference the correct column. I've got it! Thanks for you help :) Nadia -----Original Message----- This works for me: =SUMIF(A:A,"*abc*",B:B) where the values to be summed are in a separate column. Are you trying to extract the values from the text cells? In article , "Nadia" wrote: I have a column that contains the following text cells: abc - 123 abc - 455 abc - 333 zzzzsyt wwtrtzz I just want to sum up the values corresponding to any cell that has an "abc - " in it. How do I do this? I've tried: =SUMIF(range,"*abc*",range) but it doesn't work. . |
#4
|
|||
|
|||
Would be easier if you had two columns.
This works if the last three characters are the number in each cell =SUMPRODUCT(--(LEFT(F1:F5,5)="abc -"),VALUE(RIGHT(F1:F5,3))) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Nadia" wrote in message ... I have a column that contains the following text cells: abc - 123 abc - 455 abc - 333 zzzzsyt wwtrtzz I just want to sum up the values corresponding to any cell that has an "abc - " in it. How do I do this? I've tried: =SUMIF(range,"*abc*",range) but it doesn't work. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF PROBLEM | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |