| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf with date range
I have a formula:
=SUMIF(Details!AE$1:BQ$1,"=CurDate",Details!AE2:B Q2) AE1:BQ1 on the Details page are dates CurDate is the current date and is a named cell AE2:BQ2 on the Details page are values I need the formula to look at the date range AE1:BQ1 and determine if it's value is greater than or equal to the value of the CurDate. If it is then sum the fields in AE2:BQ2. The formula I have presented above does not work.....any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif date range | Excel Worksheet Functions | |||
| Sumif for Date Range | Excel Discussion (Misc queries) | |||
| Sumif with two criteria including a date range | Excel Discussion (Misc queries) | |||
| SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
