Creating Sumif in Airtable

[Chelsea_Boss1]

I am attempting to perform a task in which I’d typically use a Sumif formula. I’m trying to “sum” the extended price “if” the sales rep column equals the reps name.

For example:
Extended Price Sales Rep
$400 Mike
$250 Justin
$150 Mike

Result:
Mike = $550
Justin = $250

Is there a formula / work around for this?

[atusr]

Maybe you can customize the following base/template:

Airtable

Split Bills & Expenses - Airtable Universe

Split shared bills & expenses, and find out who owes what to whom. ​ For Teams of two, roommates & couples, the best alternative to TriCount, SplitWise,...

I hope it helps! :winking_face: