 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2006Function 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 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 > 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 [quoted text clipped - 5 lines] > > Mac 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. > Try something like this: > [quoted text clipped - 22 lines] > > > > Mac 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 > Ron, > I see that I was not clear in what my end result is - each row that has May [quoted text clipped - 27 lines] > > > > > > Mac Correction: The formula is: B1: =SUMIF(A1:A100,"*May*",B1:B100) NOT B1: =SUMIF(A1:A100,"*May*",A1:A100) *********** Regards, Ron XL2002, WinXP > Ron, > I see that I was not clear in what my end result is - each row that has May [quoted text clipped - 27 lines] > > > > > > Mac Excellent - thank you!!! > Correction: > [quoted text clipped - 40 lines] > > > > > > > > Mac |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.