SEARCH and FIND

[linch]

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

[tim201110]

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

[Sam Capricci]

the way you've written it, it will work with an individual cell such as =SEARCH(B1,$A6) and =FIND(C1,$A3)

[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

[linch]

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.

[FioreMatto]

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

[linch]

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

Sorry. Here is a hopefully better example. The first sum below tag1 should be 10+3=13, because rows 8 & 10 contain tag1. Sum below tag2 should be 5, because only 9th row contain tag2 (s. attachment).

My (wrong) logic is:

1) SEARCH(C2;Table3[tag]) should return {#VALUE! 1 #VALUE! 1 #VALUE!}

2) ISNUMBER() should transform it to {FALSE TRUE FALSE TRUE FALSE}

3) Table[amount] is {empty 10 5 3 empty}

4) SUMIF(Table[amount],ISNUMBER()) should sum the second and the fourth elements of Table[amount]. {10 + 3} = 13

[Pete_UK]

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

[linch]

Thanks a lot, Pete!

it helped indeed.

[Pete_UK]

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