Forum Discussion
Solved
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.
=SUMIFS('TRADES ENTRY'!$E:$E,'TRADES ENTRY'!$K:$K,DASHBOARD!B6,'TRADES ENTRY'!$F:$F,DASHBOARD!$C$3,'TRADES ENTRY'!$G:$G,IF(DASHBOARD!$B$3="","*",DASHBOARD!$B$3))
This formula returns the expected result in my sample worksheet.
never mind! i copied only the last bid of your formule, i didn't see the part IF(DASHBOARD......
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!
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.