Forum Discussion

Copper Contributor

Jun 28, 2021

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.

Formulas and Functions

Platinum Contributor

Jun 28, 2021

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.

Copper Contributor

Jun 29, 2021

Every other column is add then subtract from B4-AB4, so the sum formula won't work.

NikolinoDE
Platinum Contributor
Jun 29, 2021
Mangoorani
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)

Resources