How to add positive and negative numbers based on the text on another cell?

[Helenmhp]

Hi, on daily based I get a list of transactions (columns E:G) and they are divided by subtitles (cells in blue e.g. e5). I need to add the values related to each subtitle (as shown in red B6:C9). Basically is adding, for each subtitle, all the cells (column G) related to "Trades" and to "OUT" (column E). I need to build an excel with the formulas where I can just paste the daily translations (columns E:G) and the sums get done; please note that the Subtitles, Trades and OUT names will change.

Any ideas how to handle this? Thank you so much!

 

[sandy666]

I suggest to use XL2BB instead of picture to post your example