HELP! SUMIF / IF help

[Rachie1987]

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!!

 

[Pete_UK]

Try this:

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

Hope this helps.

Pete

 

[Jim Thomlinson]

=sumif(C1:C136, "<" & J2, H1:H136)

 

[Jim Thomlinson]

sorry should be...

=sumif(C1:C136, "<=" & J2, H1:H136)

 

[Jacob Skaria]

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