I have a formula that is supposed to return a value in one column based on multiple criteria in multiple columns. One of the criteria is that if the criteria cell is blank ("") or the word "ALL" is selected then the criteria for the column will be blank or not blank. The other criteria option is a specific match. How do you specify that the criteria includes everything or a specific value?
Formula in I16 = =SUMIFS($G$3:$G$16,$B$3:$B$16,IF(OR(J15="",J15="ALL"),">="&"",J15),$C$3:$C$16,IF(OR(J11="",J11="ALL"),">="&"",J11),$D$3:$D$16,IF(OR(J12="",J12="ALL"),">="&"",J12),$E$3:$E$16,IF(OR(J13="",J13="ALL"),">="&"",J13),$F$3:$F$16,IF(OR(J14="",J14="ALL"),">="&"",J14))
Formula in I16 = =SUMIFS($G$3:$G$16,$B$3:$B$16,IF(OR(J15="",J15="ALL"),">="&"",J15),$C$3:$C$16,IF(OR(J11="",J11="ALL"),">="&"",J11),$D$3:$D$16,IF(OR(J12="",J12="ALL"),">="&"",J12),$E$3:$E$16,IF(OR(J13="",J13="ALL"),">="&"",J13),$F$3:$F$16,IF(OR(J14="",J14="ALL"),">="&"",J14))