Gabrielle_erre
New Member
- Joined
- Jan 3, 2019
- Messages
- 21
Hey, I'm new here and looking to resolve the next problem.
=SUMIFS(Tabelle2!I:I, Tabelle2!A:A,"*"&A2&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*")
<tbody>
</tbody>
How can I modify the formula in order to have 0 or emty cell in B4 and B5 if in A4 and A5 is nothing shown?
Column A from the table is result of formula =IFERROR(INDEX(Tabelle2[SKU], MATCH(0,INDEX(COUNTIF($A$1:A25,Tabelle2[SKU]),0),0)),"")
Thanks in advance!
=SUMIFS(Tabelle2!I:I, Tabelle2!A:A,"*"&A2&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*")
A | B | C | |
1 | SKU | Result of SUMIFS | applied FORMULA for B |
2 | Black | 100 | =SUMIFS(Tabelle2!I:I,Tabelle2!A:A,"*"&A2&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*") |
3 | White | 100 | =SUMIFS(Tabelle2!I:I,Tabelle2!A:A,"*"&A3&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*") |
4 | 200 | =SUMIFS(Tabelle2!I:I,Tabelle2!A:A,"*"&A4&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*") | |
5 | 200 | =SUMIFS(Tabelle2!I:I,Tabelle2!A:A,"*"&A5&"*",Tabelle2!C:C,"*"&List_daily!$L$35&"*") |
<tbody>
</tbody>
How can I modify the formula in order to have 0 or emty cell in B4 and B5 if in A4 and A5 is nothing shown?
Column A from the table is result of formula =IFERROR(INDEX(Tabelle2[SKU], MATCH(0,INDEX(COUNTIF($A$1:A25,Tabelle2[SKU]),0),0)),"")
Thanks in advance!