Combine multiple rows when they have the same word

[DarwinC12]

Can anyone help me how to combine multiple rows and sum its value when they have the same words?
Example:

User ID	Category ID	Category	Value
0001	C001	Agent	1
0002	C002	Client	2
0001	C003	Agent	4

Result:

User ID	Category ID	Category	Value
0001	C001	Agent	5
0002	C002	Client	2

[Joseph_Seddik]

First, you need to read this:

Data: The Essentials - AppSheet Help

And this:

References between tables - AppSheet Help

[DarwinC12]

Thank @Joseph_Seddik I appreciate it.

[DarwinC12]

Can anyone give me and example?

[Joseph_Seddik]

Sure. There is more than one way, the most suitable of which depends on your exact case. So you might want to describe your need in a bit more detail.

A general, might not be so efficient answer, is to use something like this:

SUM( SELECT(table[Value], AND(
  [User ID] = [_ThisRow].[User ID],
  [Category ID] = [_ThisRow].[Category ID]
)))