Forum Discussion
ignoring black cell (or part of the formule)
=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.
i copied only the part ="",",*",DASHBOARD!$B$3))
thank you so much!! you're a life saver!!
i was bussy for a full week with this, and looked so many video's but could not find it..
thanks again! have a great day!
You are welcome! Have a great day as well.
- 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!=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!