how to write this modified sumif

[bigdan]

Custody	50
Transaction	70
Revenue	1000
Custody/Txn	?

<tbody>
</tbody>

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