| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct including previous years
=sumproduct(d18:d1000,--(year(b18:b1000)=year(now())))
I need a formula to add all the values in d18:d1000. All the previous years including current year. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct including empty cells | Excel Discussion (Misc queries) | |||
| Calculating to add years - including leap year | Excel Worksheet Functions | |||
| SUMPRODUCT - Count Previous Month | Excel Worksheet Functions | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Changing dates entered in 2005 to previous years | Excel Worksheet Functions | |||
Threaded Mode
