My SUMIFS
formula gets its criteria from a drop down filter. Need to be able sum all values IF the filter is left blank.
=SUMIFS(Data!AX:AX,Data!J:J,B2)
Use an IF
function to determine whether the criteria cell is blank, and if it is, use a "regular" SUM
function.
Something like,
=IF(B2="",SUM(Data!AX:AX),SUMIFS(Data!AX:AX,Data!J:J,B2))