Is there a way to SUMIFS with multiple criteria true or false

Question

I want to add up the entire value according to the correct criteria and determine if the final condition is true or not. If true, the sumifs will be performed; otherwise, "0" will be returned. The value in each column will be zero if there is no date.

D9=SUMIFS(STORE!$C$6:$C$1000;STORE!$A$6:$A$1000;"*"&SUMMARY!$D$5&"*";STORE!$D$6:$D$1000;"*"&SUMMARY!$C$9&"*";STORE!$E$6:$E$1000;"*"&SUMMARY!D8&"*")

Answer 1

You can add this as the  last criteria:

=SUMIFS(STORE!$C$6:$C$1000;STORE!$A$6:$A$1000;""&SUMMARY!$D$5&"";STORE!$D$6:$D$1000;""&SUMMARY!$C$9&"";STORE!$E$6:$E$1000;""&SUMMARY!D8&"";STORE!$AA$6:$AA$1000;TRUE)

STORE!$AA$6:$AA$1000: False or True column