Forum Discussion
Solved
Summing values with unique properties
Hello! My table is copied below. I am wanting to sum the dollar amounts in column Estimate Value per each scope of work, but only include one of the scope of work values per project name, but then ex...
=IFERROR(SUM(INDEX(D5:D35,XMATCH("Sheetmetal" &UNIQUE(FILTER(A5:A35,(C5:C35="Sheetmetal")*(F5:F35<>"Contractor Not Awarded"))),C5:C35&A5:A35))),0)
This returns the expected result in my sheet.
=IFERROR(SUM(INDEX(D5:D35,XMATCH("Sheetmetal" &UNIQUE(FILTER(A5:A35,(C5:C35="Sheetmetal")*(F5:F35<>"Contractor Not Awarded"))),C5:C35&A5:A35))),0)
This returns the expected result in my sheet.
That worked! Seems like a simple solution but you don't know how long I have been stumped on this. I really appreciate it!