I have the below set of project data in Excel. The projects are dynamic and can change each time the data is refreshed
Project Resource Cost
P1 R1 125
P2 R1 125
P1 R2 100
P1 R3 90
P3 R4 110
P2 R2 100
P2 R3 90
I need to summarize the data as below pulling the unique projects and using a sumif to summarize the data
Project Resource Cost
P1 315
P2 315
P3 110
Any suggestions on a way to accomplish this?
Thanks in advance
mpillow (BOB member since 2009-10-21)
I didn’t see where you had “unique” rows that needed to be summarized. Are you not just summarizing by Project?
If so, return all of your data, and remove the Revision (or whatever column 2 is supposed to represent). If your “Cost” is defined as a measure with the aggregate projection set to “Sum”, it will aggregate them for you auto-magically.
digpen 
(BOB member since 2002-08-15)
Thanks for the reply. What I have is data pulled from project into excel. So I am trying to summarize the data within Excel at a Project or even a milestone level.
I am trying to determine the foumula(s) in Excel which would take the P1, P2, … from the top set of data and pull the unique values for use in the aggregation.
So what I am trying to figure out is
From
P1
P2
P1
P3
P2
P4
To
P1
P2
P3
P4
Thanks
mpillow (BOB member since 2009-10-21)
Why don’t you use the filter function in Xcelsius?
link the filter to your first column - only P1 - P2 - P3 - P4 will be visible.
Based on your selection (which you write down in cell C1 for example), use a sumif in excel:
sumif(=SUMIF($A$1:$A$20;$C$1;$B$1:$B$20)
wimvg 
(BOB member since 2010-02-12)
Just to give an update. I am now using the below formula in excel to identify and eliminate the dulicates.
=IF(ISERROR(MATCH(A4,$C$3:$C$3,0)),A4,"")
A4 is the current cell within the range I am de-duping. C3 is the cell above the top cell within my de-duped range.
In the next line down C5 I have this formula
=IF(ISERROR(MATCH(A5,$C$3:$C$4,0)),A5,"")
I am checking the next cell in the range for de-duping. Notice the range $c$3:$C$4 is expanding to include the de-duped range prior to the current cell C5.
Now all I need to do is figure out how to bring them all together for my display. If anyone knows of a spreadsheet type object in Xcelsius which ignores blanks within the range (Not just at the end), let me know.
Thanks
mpillow (BOB member since 2009-10-21)