Sum according a list

Hi,

I have a list, with 4 itens.
I need to group, according one specific item.

In realy, I need to sum, according one specific item.

In this case, the item that will be the boss is the LEVEL.
The item that should sum, if is in the same LEVEL is VOLUME (i created by formula)

The others items will be repeated according a string.

Before inputting your Levels and your Volumes into the List.Create sort them and separate them by Level.

1 Like

Nick,
Thanks for the help and sorry for the delay.

Is almost working.

image

So you only need each item in your final list to appear once? Use List.UniqueItems.
Or am I misunderstanding something?

Nick,

I tried by another way, understanding what you did, just changing a little.

It Worked.

Thanks again.

image

Nick,

In this example, you show me how to sum according one condition.
To make sum according two conditions… is very different? Should i open a new topic?
Example: Should sum if has the same level and the same name.

Same concept, just sort your list twice before summing it. It’s a little more complicated but shouldn’t be too bad.

:confused:

tried, but, not! kkkk

OK, maybe a little more complicated that I expected, but most of that was grouping the sublists once I had them sorted. See if this works for you:

hahaha… it worked!

Thanks Nick