Hi,
I am trying to sum a list of data using mutiple criteria and I cannot figure out the best way. An example of the data is as follows
Col A Col B Col C Col D
Year Period Type Value
2012 9 EPC 10500
2012 11 EPC 26500
2012 12 ENB 750
2013 2 OWN 8236
2013 9 PLN 1200
2013 12 EPC 30000
I want to sum Col D by the various Types in Col C, however I need to do it upto the current period -1. So if for example we are in Period 12 2013, then sum all the sum of spend for Type EPC upto Year 2013 Period 11.
I cannot figure out how to do this without excluding the Year 2012 Period 12 values as well as Year 2013 Period 12.
any suggestions greatly received
I am trying to sum a list of data using mutiple criteria and I cannot figure out the best way. An example of the data is as follows
Col A Col B Col C Col D
Year Period Type Value
2012 9 EPC 10500
2012 11 EPC 26500
2012 12 ENB 750
2013 2 OWN 8236
2013 9 PLN 1200
2013 12 EPC 30000
I want to sum Col D by the various Types in Col C, however I need to do it upto the current period -1. So if for example we are in Period 12 2013, then sum all the sum of spend for Type EPC upto Year 2013 Period 11.
I cannot figure out how to do this without excluding the Year 2012 Period 12 values as well as Year 2013 Period 12.
any suggestions greatly received