#### Gabrielle_erre

##### New Member

- Joined
- Jan 3, 2019

- Messages
- 21

=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!