Jun 27 2021 11:37 PM
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.
Jun 27 2021 11:48 PM
Jun 27 2021 11:55 PM
@Mangoorani Not sure if your example is realistic, but if it is you could perhaps consider entering all the numbers that should be subtracted as negative numbers. Then the formula in your example could become =$B4 - SUM($D4:$AB4)
Jun 28 2021 01:06 AM - edited Jun 28 2021 01:07 AM
That would be the shortest option because your data is uninterrupted from B4 to AB4.
Formula =SUM(B4:AB4)
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jun 28 2021 01:28 AM
Jun 28 2021 08:33 PM
Jun 28 2021 08:33 PM
Jun 28 2021 08:39 PM
Jun 28 2021 11:21 PM
@Mangoorani Perhaps you missed a few words in my earlier reply, where I suggested that you could perhaps enter the numbers that need to be subtracted as negative numbers. Then you can use the SUM function as demonstrated in the picture below.
Jun 28 2021 11:36 PM - edited Jun 28 2021 11:47 PM
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)
Jun 29 2021 01:38 AM
You wanted the shortest formula possible to perform the calculation you sent.
You got that from most of them, including me.
Send a file (without sensitive data) and use it to describe what exactly you want to accomplish.
Otherwise there is no point in smelling our fingernails.
I would recommend that you read this link carefully, as I recommend to most of you. This will save you a lot of time for yourself and for the helpers. Time that others might have at their disposal.
Willkommen in Ihrem Excel-Diskussionsraum!
I hope you also enjoy Excel.
I would be happy to see you ask here again.
Ask, ask as much as you like, just please with the given rules.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)