Sum Total points with two column which contain same Email ID

I Sum Total points with two column which contain same Email ID

Team 1 Datatype ref
Team 2 Datatype ref
Point team 1 Datatype number
Point team 2 Datatype number

I need to sum the point team 1 column where Email ID is same in Team 1 and Team 2
Get result in another column Overall Points
eg:
I need result ,abcd@gmail.com has points in Point Team 1 as 11,Point Team 2 as 21
In overall Points β€”>31

Please help me with the expression to get this

Hi @Badminton_Scoring

Welcome to the community !

There is no relation between what you describe and your screenshot, can you explain with a consistent visual example ?
(and…11+21 = 32 :wink: )

2 Likes

For reference:

2 Likes