| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to sum a list of rows with different text except for one
I have a list of projects by row and I need to sum the lines that have one
key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to sum a list of rows with different text except for one
Try something like this:
For a list of Projects in A1:A100 This formula counts the cells that contain the word "May" B1: =COUNTIF(A1:A100,"*May*") Note: in that configuration, "Mayberry" counts as a match. Post back if that is not OK. Does that help? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: I have a list of projects by row and I need to sum the lines that have one key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to sum a list of rows with different text except for
Ron,
I see that I was not clear in what my end result is - each row that has May has a dollar value in another column (Row 1 Column A May 2390i3094 Row 1 Column B $5000 )and I need the dollar values to add up for all May rows. "Ron Coderre" wrote: Try something like this: For a list of Projects in A1:A100 This formula counts the cells that contain the word "May" B1: =COUNTIF(A1:A100,"*May*") Note: in that configuration, "Mayberry" counts as a match. Post back if that is not OK. Does that help? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: I have a list of projects by row and I need to sum the lines that have one key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to sum a list of rows with different text except for
OK...then try this:
For a list of Projects in A1:A100 This formula sums the cells in Col_B where the corresponding cell in Col_A contains the word "May": B1: =SUMIF(A1:A100,"*May*",A1:A100) Is that what you're looking for? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: Ron, I see that I was not clear in what my end result is - each row that has May has a dollar value in another column (Row 1 Column A May 2390i3094 Row 1 Column B $5000 )and I need the dollar values to add up for all May rows. "Ron Coderre" wrote: Try something like this: For a list of Projects in A1:A100 This formula counts the cells that contain the word "May" B1: =COUNTIF(A1:A100,"*May*") Note: in that configuration, "Mayberry" counts as a match. Post back if that is not OK. Does that help? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: I have a list of projects by row and I need to sum the lines that have one key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to sum a list of rows with different text except for
Correction:
The formula is: B1: =SUMIF(A1:A100,"*May*",B1:B100) NOT B1: =SUMIF(A1:A100,"*May*",A1:A100) *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: Ron, I see that I was not clear in what my end result is - each row that has May has a dollar value in another column (Row 1 Column A May 2390i3094 Row 1 Column B $5000 )and I need the dollar values to add up for all May rows. "Ron Coderre" wrote: Try something like this: For a list of Projects in A1:A100 This formula counts the cells that contain the word "May" B1: =COUNTIF(A1:A100,"*May*") Note: in that configuration, "Mayberry" counts as a match. Post back if that is not OK. Does that help? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: I have a list of projects by row and I need to sum the lines that have one key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function to sum a list of rows with different text except for
Excellent - thank you!!!
"Ron Coderre" wrote: Correction: The formula is: B1: =SUMIF(A1:A100,"*May*",B1:B100) NOT B1: =SUMIF(A1:A100,"*May*",A1:A100) *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: Ron, I see that I was not clear in what my end result is - each row that has May has a dollar value in another column (Row 1 Column A May 2390i3094 Row 1 Column B $5000 )and I need the dollar values to add up for all May rows. "Ron Coderre" wrote: Try something like this: For a list of Projects in A1:A100 This formula counts the cells that contain the word "May" B1: =COUNTIF(A1:A100,"*May*") Note: in that configuration, "Mayberry" counts as a match. Post back if that is not OK. Does that help? *********** Regards, Ron XL2002, WinXP "Mac Landers" wrote: I have a list of projects by row and I need to sum the lines that have one key word. For example I have May jakdjfld, May a0934u0, May 2309u09, etc. I want to sum all the rows with the word May in it. I greatly appreciate your help. Thanks! Mac |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells within a list to display a certain text but have different v | Excel Discussion (Misc queries) | |||
| Vlookup of list with text and number | Excel Discussion (Misc queries) | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| Import only certain rows of a huge text file | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Linear Mode
