Can you use <=Today() for criteria if my Range A2:A29 (are Dates) and the
column i want to total is B2:B28

Formula is =SUMIF(A2:A30,"<=TODAY()",B2:B30)

The reult is £0 when i expected it to have added up the amounts (01/02/08 -
12/02/08 in Column A ) in Column B