summing up numbers when criteria match
Posted
by
Hisham
on Super User
See other posts from Super User
or by Hisham
Published on 2014-08-18T20:09:12Z
Indexed on
2014/08/18
22:24 UTC
Read the original article
Hit count: 366
microsoft-excel
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.
© Super User or respective owner