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!
Help_excel.PNG
Bookmarks