Help please, with Adding Cells with using a date criteria

[Rachie1987]

I have a spreadsheet which lists loads of orders and the dates of orders, we
have got the total value of the orders and we also want in one cell the total
value of orders within the last sort of 3 months etc. I tried doing a Sumif
statement

=SUMIF(C9:I48,">=C55",I9:I48)

Where in cell C55 i put the date which we want to add orders up from, but
its not working, can someone help me correct it?? Is it because its a date?


The Spreadsheet looks like this:

Date Description Value £

01.06.08 IQM £5,173.39
01.08.08 CAR SHOWROOM DISPLAY-BANNERS £3,500.00

 

[Roger Govier]

Hi

Try
=SUMIF(C9:I48,">="&C55,I9:I48)