# Finding a tag or text within text as part of SUMIFS formula

1. ## Finding a tag or text within text as part of SUMIFS formula

I've been looking at SUMIFS for the first time. In the MS help, they refer to using wildcard characters ? and *

One thing I would like to be able to do is use a formula like this to sum the contents of column O:O whereever there is mention of Mick within column Y:Y.

Column Y:Y contains notes up to 100 characters against each line item to do with delivery times, contact details etc.

=SUMIFS(Sheet1!O:O,Sheet1!Y:Y,"=*mick")

Thanks

tw

2. ## Re: Finding a tag or text within text as part of SUMIFS formula

You might like to put an asterisk at the end of the text as well:

=SUMIFS(Sheet1!O:O,Sheet1!Y:Y,"*mick*")

Also, the = is not necessary as it is implied if omitted.

Hope this helps.

Pete

3. ## Re: Finding a tag or text within text as part of SUMIFS formula

Lovely thanks Pete

Not essential to my life but is there a formula that can refer to a separate cell where the name Mick was entered and then find the text within the text ?

Thanks again..

Tw

4. ## Re: Finding a tag or text within text as part of SUMIFS formula

Yes, put Mick in cell Z1 (say), then you can have this:

=SUMIFS(Sheet1!O:O,Sheet1!Y:Y,"*"&Z1&"*")

Hope this helps.

Pete

5. ## Re: Finding a tag or text within text as part of SUMIFS formula

Brilliant thanks again Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1