Forum Discussion
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...
=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.
sorry for bothering you again. but one last question.
i try to make it also for the second dropdownlist (long/short or empty cell, but i can't use IF twice right ?
do i use AND than and how will the formule look?
thank you so much!
i try to make it also for the second dropdownlist (long/short or empty cell, but i can't use IF twice right ?
do i use AND than and how will the formule look?
thank you so much!
=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.
- Thank you so much again!!
don't know what i'm doing wrong, i tried the same thing and it didn't work.
but yours works! you made my day!
thank you!