Add up values of range of cells, if the corresponding column is emply

[brianparrish]

I have a range of cells in column C (C1:C100) that has dates in them. In column B (B1:B100), there are dollar amounts. Some of the cells in column C don't have dates (yet). I'd like to be able to add up the dollar amounts in column B that don't have corresponding dates is column B.

Example

B C
1 100 01/01/19
2 299 02/09/19
3 150
4 200
5 300 03/03/19

150+300=450, where the function ignores B1, B2, & B5.

Thanks in advance!

 

[CalcSux78]

Try SUMPRODUCT:

Excel 2010

	A	B	C
1		100	1/1/2019
2		299	2/9/2019
3		150
4		200
5		300	3/3/2019
6		350

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B6 =SUMPRODUCT(--(C1:C5=0),B1:B5) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[brianparrish]

Try SUMPRODUCT:

Excel 2010

	A	B	C
1		100	1/1/2019
2		299	2/9/2019
3		150
4		200
5		300	3/3/2019
6		350

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B6 =SUMPRODUCT(--(C1:C5=0),B1:B5) <tbody> </tbody>

<tbody>
</tbody>

Awesome! That works great. Thanks again!!

 

[DanteAmor]

You can also use

=SUMAR.SI(C1:C100,"",B1:B100)