D
Drew
I couldn't post a follow up, so I've created a new message here...
From: Jerry W. Lewis (post_a_reply@no_e-mail.com)
Subject: Re: SUMIF & Partial Strings
Date: 2003-01-27 02:14:06 PST
Use...
=SUMIF(A3:A29, "=*Alls*", B3:B29)
or
=SUMIF(A3:A29, "=*" & A52 & "*", B3:B29)
where A52 equals "Alls"
This way, if you have two entries that begin "Alls", they will be added together.
Drew.
---------------------------------------------------------------
From: Mike Copeland ([email protected])
Date: 2003-01-27 20:58:31 PST
Well, I was hoping to do the work with substrings somehow - like
"Alls" for the "Allstate Insurance" string. However, your simple,
straight-forward answer made me see that using the whole field is all I
need. And it works! Thanks, Jerry.
From: Jerry W. Lewis (post_a_reply@no_e-mail.com)
Subject: Re: SUMIF & Partial Strings
Date: 2003-01-27 02:14:06 PST
Use...
=SUMIF(A3:A29, "=*Alls*", B3:B29)
or
=SUMIF(A3:A29, "=*" & A52 & "*", B3:B29)
where A52 equals "Alls"
This way, if you have two entries that begin "Alls", they will be added together.
Drew.
---------------------------------------------------------------
From: Mike Copeland ([email protected])
Date: 2003-01-27 20:58:31 PST
Well, I was hoping to do the work with substrings somehow - like
"Alls" for the "Allstate Insurance" string. However, your simple,
straight-forward answer made me see that using the whole field is all I
need. And it works! Thanks, Jerry.