I have a quick spreadsheet I'm throwing together:
=SUMIF(D12:D,"=Austin",B12:C)
=SUMIF(D12:D,"=Corey",B12:C)
These work fine. The data for D is based on a drop down with the values Austin
, Corey
, Both
.
The data for B & C is: |Amount | Qty |
. However, if you use:
=SUMIF(D12:D,{"=Austin","=Both"},B12:C)
it returns only Austin
results.
How would you go about doing this?
Should work as an array formula (eg entered with Ctrl+Shift+Enter).