how to solve a problem in exel?

It's not clear to me exactly what you are trying to do, and the picture does not allow for any exploration of the data. Perhaps a better explanation with an actual spreadsheet file uploaded to the forum would help us understand better.

If I had to guess, it looks to me like this will end up being a pivot table operation or a SUMIFS() function or something similar. Are you familiar with these tools in Excel?

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. As you are new here, I will do it for you this time: https://www.mrexcel.com/board/thread...-exel.1193277/)

This thread has been tagged as solved - is it?

I have removed the solved tag for you.

Since no one seems to have responded over at mrexcel, I will venture this response. I'm still not sure I understand what you are trying to do or what logic you intend to use, but I notice that =SUMIFS(C2:C133,B2:B133,"*"&A2&"*") in to je tacno2.xlsx sheet2 returns 613.8. je tacno 1.2.xlsx suggests that you want the result to be 3*175+88 which is 613 -- essentially the same as the SUMIFS() but ignoring the hidden decimals in the original data.

As I said, this feels to me like a SUMIFS() or pivot table kind of problem. If you can help us understand the exact logic you are using to decide which values to sum, we should be able to help you program the conditional summation(s) into Excel.

As expected, your gifs seem show a conditional sum problem (unless I am completely misunderstanding and you really want a conditional text concatenate operation, which would probably be best handled by a TEXTJOIN() function if you have access to it).

But the thing I am really not understanding is the logic of how you choose what to sum or concatenate. The gifs show you adding/concatenating values from column B where column A contains the desired text. But, looking through the results in to je tacno 1.2.xlsx, I see cases where you did not sum/concatenate every entry. For example, the "e-I" case shows only 175, but when I look through the list in je tacno 2.xlsx I see three entries -- 175+17+0. Why did you not include these other two entries in the sum/concatenate?

It still feels like a SUMIFS() function. Other than I didn't include absolute referencing, does the SUMIFS() function I proposed in post #7 work correctly? What does it need to do differently?

You indicate that the result for 6-đ should be 37. When I search to je tacno 2.xlsx Sheet2, I see that 6-đ is included in rows 11, 31, 49, 65, 79, 92, 94, and 96. Only row 31 contains the value of 37. Why choose only row 31 and not include the values from the other rows containing 6-đ?

Please Login or Register  to view this content.

I had forgotten that I had added a header row so I could use a filter to find entries, so my row numbers are 1 larger than your row number. But it looks like the proposed SUMIFS() is correct. Here it is again, adding absolute external references for easy copying (entered in B1 of to je tacno 1.2.xlsx sheet1):

=SUMIFS(['to je tacno 2.xlsx]Sheet2'!$C$10:$C$134,['to je tacno 2.xlsx]Sheet2'!$B$10:$B$134,A1) note the mix of relative and absolute references for easy copying, then copy/paste/fill to the bottom of the list.

Rule 03: Cross-posting Without Telling Us Again!

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future or risk punitive measures If you have posted at any other sites, please add them to your post and advise us

https://www.msofficeforums.com/excel...blem-exel.html

Originally Posted by Victoriaviolet

follow these steps please.

1- In Excel 2016 for Mac: Click Data > Solver.
2- After you define a problem, in the Solver Parameters dialog box, click Options.
3- Select the Show Iteration Results check box to see the values of each trial solution, and then click OK.
4- In the Solver Parameters dialog box, click Solve.

@Victoriaviolet Your post is in no way related to the question. Repeated instances will result in infractions or a ban.