| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumproduct including previous years
Unless you have future dates in Column D along with non-zero values in
Column B, wouldn't you just want this? =SUM(D18:D1000) If you do actually have future dates that you have to filter out, try this... =SUMPRODUCT(D18:D1000,--(Year(B18:B1000)<=YEAR(NOW()))) -- Rick (MVP - Excel) "tleehh" wrote in message ... =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. |
| Reply |
| 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 | |||
Linear Mode
