Need help summing two columns of data if data is present in a third column

[mdaniels1982]

Hello all,
I'm looking to have a cell show the total pieces on hand in the yellow cell. To get the first value I need to sum the quantities in column B if there is a date in column C. Then in the yellow box I want the sum of the quantities in column F subtracted from the first value.

So basically I only want it to recognize the quantity in column B if there is a date in column C. If the formula was in there the yellow cell would show 11.

Can anyone help me out?

Thanks,
Matt

[hemesh]

first unmerge the cell then try this
=SUM(IF((C3:C5<>""),B3:B5)) copy paste then hold control and shift then hit enter to make it array formula

or

Try this =SUMPRODUCT(--(C3:C5<>"")*(B3:B5)) and hit control enter

[hemesh]

find attached with both formula.

If this helps click" * " in the bottom left corner of my post and mark thread as solved.

[mdaniels1982]

Thanks hemesh. Now i need it to subtract the sum of the values in column F.

Cancel that.... I got it. Thanks again.

[hemesh]

You are welcome Mdaniels. If your query is solved then mark the thread as solved

[hemesh]

Thanks for the rep!!