Question: I am working on a Sumifs that has 2 different criteria in Col B and the 3rd criteria in Col F.
If all 3 criteria are met then I am going to sum the values in Col Q.

I have this so far and it returns a 0. I tried to tweak it every way I am aware of and still no luck.

```
=SUMIFS($Q$4:$Q$2700, $B$4:$B$2700, "=AUS", $B$4:$B$2700, "=VCO", $F$4:$F$2700, "=TRB")

```

Answer: 
The formula you provided returns 0 every time because the value in `B` cannot be both `AUS` AND `VCO`, it's one or the other.

As far as I know (someone correct me if I'm wrong), there's currently no way to have a conditional statement in a single criteria range (e.g. `"=AUS" OR "=VCO"`). A workaround could be the following:

> 
> =SUM(SUMIFS(Q4:Q8,B4:B8,{"AUS","VCO"},F4:F8,"=TRB"))
> 
> 
> 

![enter image description here](https://i.stack.imgur.com/ouVLh.png)

This sums the values in `Q` if `B` equals either `AUS` OR `VCO` **AND** `F` equals `TRB`
The problem is that you reference $B$4:$B$2700 twice. Because this column can not possibly be both AUS and VCO Column Q will never be summed.

To make this work, add a new column next to column B. Make the value of cell C4 equal to the value of B4 (=B4) and drag this formula to cell B2700 (you can also just double click on the bottom right corner of the cell to make it auto-fill to B2700). You can then use this formula:

```
=SUMIFS($Q$4:$Q$2700, $C$4:$C$2700, "=AUS", $B$4:$B$2700, "=VCO", $F$4:$F$2700, "=TRB")

```

Remember to indicate if this answer worked!