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.