Excel Formula Help

Desmo · 21-01-2009, 12:26

I've got a list of jobs I'm doing for somebody. In one column I have a price and a total at the bottom. Two columns across, I have a date that the item was actually paid for.

What I'd like to have is a total for anything that has been paid for. So how do I set a cell to check if a date has been entered, and then reference two cells to the left to check the actual figure and then add them up?

21-01-2009, 12:26	#1
Desmo The Last Airbender Join Date: Jun 2006 Location: Pigmopad Posts: 11,915	Excel Formula Help I've got a list of jobs I'm doing for somebody. In one column I have a price and a total at the bottom. Two columns across, I have a date that the item was actually paid for. What I'd like to have is a total for anything that has been paid for. So how do I set a cell to check if a date has been entered, and then reference two cells to the left to check the actual figure and then add them up? __________________