If sum

N

Neil Greenough

In column A, I have a list of payments and in Column B, the dates when the
payments were made. If the payment still hasn't been made, then the cell in
column B is blank.

What I want to work out is the total amount of payments made. So I need to
work out the sum of the values within the cells in column A IF they have a
date next to them in column B.

Any help?
 
B

bigwheel

Neil Greenough said:
In column A, I have a list of payments and in Column B, the dates when the
payments were made. If the payment still hasn't been made, then the cell in
column B is blank.

What I want to work out is the total amount of payments made. So I need to
work out the sum of the values within the cells in column A IF they have a
date next to them in column B.

Any help?
Click to expand...

Hi Neil

Seems like you'll need some formulae in column C which can check for a date
in col B and
carry the value from col A. Then total col C

2.45 22/08/2004 2.45
2.65
3.12
8.44 14/09/2004 8.44
9.51
4.75 05/07/2004 4.75

30.92 15.64


I used =IF(B2="","",A2)

Hope it helps
 
Top