The below formula will sum col H if entries in col C are greater than J2

=SUMIF(C:C,"<" & J2,H:H)

If this post helps click Yes
---------------
Jacob Skaria


"Rachie1987" wrote:

Hello
I have a spreadsheet which basically is Set out like this:

DATE, DESCRIPTION, VALUE

I have set up one cell which i type in a date and basically i want the total
to go through and add up the total value of all items with a date earlier
than the date i enter, i.e. any orders dated before 01.07.09

I have tried a IF statement =IF(C:C<=J2,SUM(H11:H136),0) but (obviously)
this only adds up all the cells not the dates, not sure what i need to put in
to make it add up the cells i want? Help!!