jessicamessina
New Member
- Joined
- Dec 8, 2017
- Messages
- 3
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
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
