SEARCH and FIND

Dear community,

I'm trying to use SEARCH function in a spreadsheet, which seems to be an easy task. However, somehow it doesn't work. FIND doesn't work also.

Most probably I am simply to dumb. But I would appreciate if you help me to understand how can one do something wrong while trying to use one simple function.

Appending a tiny test sheet.

Cheers

=or(not(iserr(search(b1,$a3:$a6))))
cse

Good evening
I think you have to explain what you want to get because the formula works correctly if you see it and do F9
get the matrix
{#VALUE!. # VALUE!. # VALUE! .4}
in fact the EE string can be found in the fourth line in position 4 and written in this way in any use you make of it must be confirmed with CTRL + SHIFT + ENTER

Originally Posted by FioreMatto

Good evening
I think you have to explain what you want to get because the formula works correctly if you see it and do F9
get the matrix
{#VALUE!. # VALUE!. # VALUE! .4}
in fact the EE string can be found in the fourth line in position 4 and written in this way in any use you make of it must be confirmed with CTRL + SHIFT + ENTER

Thank you all very much for the very quick response.

Well, if you wish, I'll start explaining what I am trying to do. Actually, I'm setting up a table, with tags in each row. And I want to be able to sum all numbers of a column, which belong to rows with some specific tag. For the beginning, I started with this manual: (can not post the link here. Please google superuser How to Label / Tag Items in a Spreadsheet)

But since the formula

Please Login or Register  to view this content.

did not work for me via plug and play, i thought understanding it could be a good idea. So started to work through it. But already then I could not even get the very first part of it work:

Please Login or Register  to view this content.

Good evening
if you share a file with some data and the result to be obtained by hand it is easier to answer

You can use wildcard characters with SUMIF, so use this in C3:

=SUMIF(Table3[tag],"*"&C2&"*",Table3[amount])

and copy to D3.

Hope this helps.

Pete

Thanks a lot, Pete!

it helped indeed.

Well, that's good to hear.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of any post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete