Forum Discussion
looking for a short formula
I have several columns that need add then subtract then add then subtract. For example, Is there a way to short the formula? Thanks, M.
I believe you could also try (edited after I saw you had uploaded a file):
=$B4-SUMPRODUCT(-1^ISERROR(SEARCH("Restock",$D3:$AB3)),$D4:$AB4)