| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding/omitting/all the values prior to todays date
using given formula by Otavio sum((B10:B20="s1")*(C10:C20<"x")*A10:A20),
how can it add all the values in colume A that is prior to todays date (dates are in colume D). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding/omitting/all the values prior to todays date
"tleehh" wrote:
using given formula by Otavio sum((B10:B20="s1")*(C10:C20<"x")*A10:A20), how can it add all the values in colume A that is prior to todays date (dates are in colume D). =SUMPRODUCT((B10:B20="s1")*(C10:C20<"x")*(D10:D20 <TODAY()), A10:A20) Or do you mean simply: =SUMPRODUCT(--(D10:D20<TODAY()), A10:A20) or alternatively: =SUMIF(D10:D20, "<" & TODAY(), A10:A20) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding/omitting/all the values prior to todays date
I hope Otavia gave you SUMPRODUCT not SUM for the formula you show
This should work =SUMPRODUCT((D10:D20<TODAY())*(A10:A20) or this =SUMIF(D10:D20,"<"&TODAY(),A10:A20) best wishes -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "tleehh" wrote in message ... using given formula by Otavio sum((B10:B20="s1")*(C10:C20<"x")*A10:A20), how can it add all the values in colume A that is prior to todays date (dates are in colume D). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do count a set of values that are only in todays date | Excel Discussion (Misc queries) | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Highlighing values on todays date | New Users to Excel | |||
| Adding Column of mixed data omitting the dates | Excel Discussion (Misc queries) | |||
| Adding values for prior date intervals | Excel Worksheet Functions | |||
Linear Mode
