I'm struggling to create a formula which sums Column C IF (Column A = [name]) AND (Column B = "Possible" OR "Proposed" OR "Committed").

By : adam

By : adam

Source: Stackoverflow.com
Question!

I'm struggling to create a formula which sums Column C IF (Column A = [name]) AND (Column B = "Possible" OR "Proposed" OR "Committed").

By : adam

Answers

`=SUM(SUMIFS($C:$C,$A:$A,[name],$B:$B,{"Proposed","Possible","Committed"}))`

With some functions, e.g. `COUNTIF`

, `SUMIF`

, `COUNTIFS`

, `SUMIFS`

, you can get away with referencing entire columns with no detriment to performance, though not with functions which operate over arrays, such as `AGGREGATE`

, `SUMPRODUCT`

, and any construction requiring `CSE`

.

Regards

By : XOR LX

Use SumProduct with as the or operator rather than * as the and operator. Something like this:

```
=SUMPRODUCT(($A:$A=[name])*(($B:$B="Proposed") ($B:$B="Possible") ($B:$B="Committed"))*($C:$C))
```

By : MorganBall

You can try the following formula

`=SUMPRODUCT((A:A=[name])*(((B:B="Possible") (B:B="Proposed") (B:B="Committed"))`

```
By : Karpak
```

` `

This video can help you solving your question :)
By: admin

```
Related Questions
```

```
```

```
```