Need help creating a formula, please!

[jessicamessina]

I need help creating a formula that would look at cells to see if there is a date. If there is it should take the $ amount from another cell and then adding each time it finds a date.

Example:
cell K14 & K16 = 12/17/2017
cell K15 = blank
cell I14 = $15,555
cell I15 = $16,200
cell I16 = $22,000

Add amount from cells K14 & K16 to cell B5

 

[Ken Cowen]

Try something like this:


=SUMIF(K14:K16,"12/17/17",J14:J16)

You may want to replace the middle argument (12/17/17) with a cell reference and you will probably need to change the two ranges to reflect all your data. I assumed by "a date" you mean 12/17 not just any old date.

I hope this helps.

Ken

 

[jtakw]

Hi,

Since dates are just numbers formatted as dates, and assuming you want to sum Column I as long as there is Any date in corresponding Column K, and that cells without a Date in Column K is always Blank or does not contain any positive numbers:

Book1
	B	I	J	K
5	$37,555.00
14		$15,555.00		12/17/2017
15		$16,200.00
16		$22,000.00		12/17/2017
Sheet1

Cell Formulas
Range	Formula
B5	=SUMIF(K14:K16,">0",I14:I16)

 

[jessicamessina]

That was just too easy! Thank you for your help

 

[jtakw]

You're welcome, welcome to the forum.