=SUMIF(C:C,"<",$B:$B)

copy across

--
__________________________________
HTH

Bob

"Tia" wrote in message
...
hi

Im working on a workbook for invoicing

A10= PROJECT NAME
B10= TOTAL AMOUNT
C10=INVOICE # FOR MONTH 01/01/2008
D10= AMOUNT FOR MONTH 01/01/2008
E10=INVOICE # FOR MONTH 01/02/2008
F10=AMOUNT FOR MONTH 01/02/2008
J10=INVOICE # FOR MONTH 01/03/2008
H10=AMOUNT FOR MONTH 01/03/2008
AND I KEEP GOING WITH A NEW ONE EACH MONTH
WHAT I NEED IS
AA: ???????? TOTAL INVOICED
I WANT A FORMULA TO CALCULATE ALL THE AMOUNT PUTED IN THE AMOUT AREA
IN EACH MONTH FOR EACH PROJECT

TIA