| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Between dates
Hi,
Try this =sumproduct((B2:B15=B18)*(B2:B15<=C18)*(C2:C15)) B18 has 1/1/2010 and C18 has 8/1/2010. B2:B15 has dates and C2:C15 has amounts -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Vicki Leibowitz" wrote in message ... I have dates in 1 column and total amount (income) in another column. I need the total amounts say from 1 Jan 10 to 8 Jan 10. Logically: I want the sum total of income between 2 dates. I've been trying to figure this out for days. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
