Forum Discussion

Marktenbokkel's avatar
Marktenbokkel
Copper Contributor
Apr 16, 2024

ignoring black cell (or part of the formule)

hello,    table 1 table 2   out of the first table i collect data, to my dashboard (table 2)  the problem i have is: that under kind of trade is a dropdownlist used as a filter with...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Apr 16, 2024

    Marktenbokkel 

    =SOMMEN.ALS('TRADES ENTRY'!$E:$E;'TRADES ENTRY'!$K:$K;DASHBOARD!B6;'TRADES ENTRY'!$F:$F;ALS(DASHBOARD!$C$3="";"*";DASHBOARD!$C$3);'TRADES ENTRY'!$G:$G;ALS(DASHBOARD!$B$3="";"*";DASHBOARD!$B$3))

     

    You are welcome! I've added dropdowns in cells B3 and C3 in the attached file. This formula checks in addition if in cell C3 long/short or an empty cell is selected.

Marktenbokkel's avatar
Marktenbokkel
Copper Contributor
Apr 16, 2024
Thanks for your reaction! unfortunately it doesn't work my excel is in dutch (netherlands) maybe this gives a issue.
i get a arror

any other ideas ?

kind regards Mark
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 16, 2024

Marktenbokkel 

=SOMMEN.ALS('TRADES ENTRY'!$E:$E;'TRADES ENTRY'!$K:$K;DASHBOARD!B6;'TRADES ENTRY'!$F:$F;DASHBOARD!$C$3;'TRADES ENTRY'!$G:$G;ALS(DASHBOARD!$B$3="";"*";DASHBOARD!$B$3))

 

Which error message did you get when you opened the attached file from my first reply? I've translated the formula into dutch. Below you can see the results from my sheet. The formula works in Excel 2013 and Excel for the web on my computer.

 

Sheet "DASHBOARD":

Sheet "TRADES ENTRY":

Resources