| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM a range dependent on dates
I have projected volume in column D rows 1-30
I have dates in column B 1-30 I would like to only sum in cell d 31 up to today. Basically a MTD total. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM a range dependent on dates
In D31 try the below formula. Assume you have the dates in excel date format
=SUMIF(B1:B30,"<=" & TODAY(),D1:D30) If this post helps click Yes --------------- Jacob Skaria "Qaspec" wrote: I have projected volume in column D rows 1-30 I have dates in column B 1-30 I would like to only sum in cell d 31 up to today. Basically a MTD total. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM a range dependent on dates
Including data with today's date:
=SUMIF(B1:B30,"<="&TODAY(),D1:D30) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Qaspec" wrote: I have projected volume in column D rows 1-30 I have dates in column B 1-30 I would like to only sum in cell d 31 up to today. Basically a MTD total. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM a range dependent on dates
To sum the values in D column when corresponding B values are equal or less
than TODAY =SUMIF(D1:D30,"<="&TODAY(),B1:B30) change D1 and B1 to D2 and B2 if row 1 had labels best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Qaspec" wrote in message ... I have projected volume in column D rows 1-30 I have dates in column B 1-30 I would like to only sum in cell d 31 up to today. Basically a MTD total. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUM a range dependent on dates
Opps, I had the dates in D and values in B. Sorry!
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Qaspec" wrote in message ... I have projected volume in column D rows 1-30 I have dates in column B 1-30 I would like to only sum in cell d 31 up to today. Basically a MTD total. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation via Dependent List defined by Dynamic Range | Excel Discussion (Misc queries) | |||
| 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) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Hybrid Mode
