Hello Friends,
In this example, I couldn't figure out how to use SUMIFS (Çoketopla) formula. Let me explain what I want. As you see, the formula works when there is only the same word like "TOPRAK", "BETON", "KORUGE". On the other hand, I would like to give the "BORDÜR" and "PARKE", which appear separately in the table above, together as "BORDER-PARKE" in the summary table below. Of course, I can manually pick and collect one by one. But how can I use SUMIFS, which is a short cut? I'll be happy if you can help me.
In this example, I couldn't figure out how to use SUMIFS (Çoketopla) formula. Let me explain what I want. As you see, the formula works when there is only the same word like "TOPRAK", "BETON", "KORUGE". On the other hand, I would like to give the "BORDÜR" and "PARKE", which appear separately in the table above, together as "BORDER-PARKE" in the summary table below. Of course, I can manually pick and collect one by one. But how can I use SUMIFS, which is a short cut? I'll be happy if you can help me.