summing up numbers when criteria match
- by Hisham
I have a range of long dates from Sep 2014 till Dec 2018, and for each month I have an amount. I want to sum up the data of each year in one cell.
Example:
2014 : sum of all amounts that are in 2014
2015 : sum of all amounts that are in year 2015
Sep2014 oct2014 Nov2014 Dec2014 Jan2015 Feb2015 ...
100 200 250 150 20 50
I know that 2014 = 100+200+250+150 = 700, but I need a formula to search for all cells that include that year and sum up the numbers.