Formula to select lines below one specific category

[patriciotxk]

Hello to everyone,

I am writing in the forum because I want to create an excel sheet that returns the value that is in the excel sheet named "GASTOS" and that the value associated with the categories shown in the excel sheet "Balanço". I will upload some screenshots in order to help the readers to understand what I want to do.

Also, I going to give an example from what I want to do: I want the value that is under the "Consumíveis" category to appear in the excell sheet name "BALANÇO", and I want that all the values from each month get summed up.

The category "Consumíveis" is marked with a rectangle in red, whereas the blue arrow indicates where is the value.

Best regards,

Pedro Patrício.

[Kaper]

The data layout is rather unconvenient to do what you ask for. But to let us try to answer (and allow you to implement our ideas) it would be good idea if you follow the advice given in a yellow banner above and post not (only) screenshots, but also a workbook.

[patriciotxk]

I solved the problem. It took some time, but it's done.

[Kaper]

Good to hear so.
It would be nice if you publish (attach) small sample file with your solution for those who will find this thread using either forum's or general search tools.

[patriciotxk]

Hello, Basicaly I used the SumIf function to each element. MY sheet is made to control the values that I spent each day, so I created a sheet where I have several "objects" and within each there is a value and a category. The sumif function gathers the data from each "element", to do that I used a function made of several sumif's like for example: =Sumif(B6:D6;"name of the vategory";B7:D7) + Sumif(B12:D12;"name of the category";B13:D13) + ...)

Hope you understood,

Best regards