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: ...READ MORE
Oct 1, 2022
in Others
by
narikkadan
• 63,600 points
•
1,287 views