Excel: if year X, then sum values from multiple rows

Question

I have a table with projects, each project has multiple work packages. I need to create a formula or pivot table with the following condition:

• if year is 2015 or 2016, sum the work package amounts and show the total for the project

The result should be as seen in this screenshot:

Answer 1

If you'd like to use a formula, use SUMIFS as Luuklag suggested. For your example, assuming the layout is like this

it would be this:

=SUM(SUMIFS(D2:D6,C2:C6,{2015,2016},A2:A6,A10))

The reason is that SUMIFS by default uses only AND logic, so you need to use an array, and then an outer sum (see here for more).

Answer 2

How about this using Pivot table...?

Select 2015 and 2016 from filter.