| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding cells depending on a date | Excel Discussion (Misc queries) | |||
| Adding multiple cells meeting criteria | Excel Worksheet Functions | |||
| Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
| adding specific cells based on a corresponding date | Excel Worksheet Functions | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Threaded Mode
