Function to sum a list of rows with different text except for one

M

Mac Landers

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
 
R

Ron Coderre

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
 
M

Mac Landers

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.
 
R

Ron Coderre

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
 
R

Ron Coderre

Correction:

The formula is:
B1: =SUMIF(A1:A100,"*May*",B1:B100)

NOT B1: =SUMIF(A1:A100,"*May*",A1:A100)

***********
Regards,
Ron

XL2002, WinXP
 
M

Mac Landers

Excellent - thank you!!!

Ron Coderre said:
Correction:

The formula is:
B1: =SUMIF(A1:A100,"*May*",B1:B100)

NOT B1: =SUMIF(A1:A100,"*May*",A1:A100)

***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 
Top