Help please, with Adding Cells with using a date criteria

R

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
 
P

Pecoflyer

Rachie1987;216794 said:
I have a spreadsheet which lists loads of orders and the dates o
orders, we
have got the total value of the orders and we also want in one cell th
total
value of orders within the last sort of 3 months etc. I tried doing
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
date?


The Spreadsheet looks like this:

Date Description Valu
£

01.06.08 IQM £5,173.39
01.08.08 CAR SHOWROOM DISPLAY-BANNERS £3,500.00
Click to expand...

Hi change your formula to =SUMIF(C9:c48,">="&C55,I9:I48

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste
 
Top