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
|