What's new in Customer Journeys?

Connect and learn more! ×
Formula for sum up in specific condition — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula for sum up in specific condition

Accepted answer
119
Views
22
Comments

Summary:

Hi,

I want to create a formula that will sum up the values in other rows if those values are less than 3000.

I've created the formula in Excel, please check this screenshot:

Content (required):

I highlighted the cells that have values less than 3000. As you can see, Account A and D has values that are less than 3000 in 2023 and 2022, so the values will be summed up to Others.

I tried to modify the formula many ways in the row formula, but I keep getting an error like this:

I think because the formula is not valid.

Does anybody know how I should create the formula like in Excel?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!