Sum values preceg today

[traineeross]

I am trying to find a way of sum all values which precede todays date.

Date Payment
01/01/2007 10
01/02/2007 12
01/03/2007 11
01/04/2007 10
01/05/2007 10
01/06/2007 23
01/07/2007 10
01/08/2007 10
01/09/2007 10
01/10/2007 10
SUM 116

So if we take todays date (6th June 07) i want the formula to calculate the
value of payments made from Jan to June.

I have tried using the offset and match functions, but they only give me the
value of the cell which precedes todays date, not the value of all cells
preceding todays date.

Is there an easy way to do this?

Many thanks for you help,

Jody

 

[Pete_UK]

Try this:

=SUMIF(A2:A11,"<"&TODAY(),B2:B11)

Assumes dates are in column A and Payments in column B, with headings
in row 1.

Hope this helps.

Pete