Help please, with Adding Cells with using a date criteria
 

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

Help please, with Adding Cells with using a date criteria
 

Hi

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

--
Regards
Roger Govier

"Rachie1987" wrote in message
...
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

Help please, with Adding Cells with using a date criteria
 

Rachie1987;216794 Wrote:
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

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


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59558