| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF to add data between a range of dates
Hi, I am developing a cashflow spreadsheet, and need to add a range of values
(in column B) based on the criteria that they are relating to a set week, ie in column B has the amount to be paid, and column C has the date the amount is due. I need to find out the total amount due between 2 dates. Does anyone know how I can do this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF to add data between a range of dates
Hi
With start date in B20 and end date in B21 try this: =SUMIF(C2:C5,"=" &B20,B2:B5)-SUMIF(C2:C5,"<="&B21,B2:B5) Regards, Per "Jaspa" skrev i meddelelsen ... Hi, I am developing a cashflow spreadsheet, and need to add a range of values (in column B) based on the criteria that they are relating to a set week, ie in column B has the amount to be paid, and column C has the date the amount is due. I need to find out the total amount due between 2 dates. Does anyone know how I can do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SumIf function, How set range between dates and across worksheets? | Excel Worksheet Functions | |||
| Sumif on pulling out data from dates | Excel Worksheet Functions | |||
| Help with SUMIF using a range of dates as criteria | Excel Discussion (Misc queries) | |||
| I want to use sumif to sum up a column based on a range of dates | Excel Worksheet Functions | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
Linear Mode
