how to write this modified sumif

[bigdan]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Custody[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Transaction[/TD]
[TD]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Revenue[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Custody/Txn[/TD]
[TD]?[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to modify one of my formulas. Essentially I want to write a SUMIF statement where anytime it sees either Custody or Transactions it adds them up. I think it'd be something similar to this but I dont know what I'd put in my last argument:

=sumifs(b1:b3,a1:a3,("Custody","Transaction"))

That last part I'm stuck on.

 

[Joe4]

If checking for multiple options, you can do it like this:

=SUM(SUMIFS(B1:B3,A1:A3,{"Custody","Transaction"}))

 

[Dave Patton]

try
=SUM(SUMIFS(B1:B3,A1:A3,{"Custody","Transaction"}))

 

[bigdan]

awesome, thanks. what's the first sum function for? i would've thought that just the sumifs would do the trick.

 

[Joe4]

See here for an explanation: https://exceljet.net/formula/sumifs-with-multiple-criteria-and-or-logic