Hi,
I have two columns, A and B respectively, that contain the following values:
How can I write the SUMIF worksheet function to search for everything in column B that contains the letter "E" and if it contains that letter, it will sum the value in column A?
Please Login or Register to view this content.
Thanks...
Mike
Last edited by mbu; 01-30-2008 at 09:53 PM.
Hi Mike,
See if the following formula =SUMIF(B1:B6,"*E*",A1:A6) does the trick.
HTH
Robert
Robert,Originally Posted by Trebor76
Thanks for the response!
No, that won't work since SUMIF is looking for the exact match of "E". Somehow I need to strip off everything but the first letter and then check if what is remaining is an "E". Is there a way I can incorporate the LEFT function into the SUMIF function?
Last edited by mbu; 01-30-2008 at 09:54 PM.
Robert,
Oops! I didn't see your wildcard characters in there!
Okay, that'll work! Thanks!
Just curious...will that match any E in the cell or will it just match the first one?
I just want it to match if the E is the first letter.
Hi there,
=SUMIF(B1:B6,"E*",A1:A6) will only sum values in the range A1:A6 where the text in the range B1:B6 starts with an E. The previous formula sums the same column A range whenever there is an E anywhere within the text entry from column B.
HTH
Robert
Robert,
Thanks, that works!
Mike
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks