mardi 4 avril 2017

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

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 on the picture: enter image description here

Aucun commentaire:

Enregistrer un commentaire