Sumif from pivot table by criteria (Greater Than)
've tried all possible ways, sum if, sum product, index an match, etc. but whenever I go back and filter its also picking up the grand total number located in the pivot table.
Therefore in lieu of the correct number (example $17,393) it doubles (example $34,786)
The current formula I'm using to pull the pivot table data into a sheet named "Chart" - Cell Reference (G10)
=SUMPRODUCT(SUBTOTAL(9,OFFSET(DEBTOR!N5,ROW(DEBTOR!N5:N32)-ROW(DEBTOR!N5),,1)),--(DEBTOR!J5:J32>0))
also tried,
=SUMIFS(DEBTOR!$N$5:$N$30,DEBTOR!$J$5:$J$30,">0")
The date in the pivot table (DEBTOR)
[TABLE="class: cms_table, width: 739"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD="align: right"]Sum of Civil Dismissal[/TD]
[TD="align: right"]Sum of Civil New Filing[/TD]
[TD="align: right"]Sum of Civil Suit[/TD]
[TD="align: right"]Sum of Judgements[/TD]
[TD="align: right"]Sum of Chapter 7[/TD]
[TD="align: right"]Sum of Federal Tax Lien[/TD]
[TD="align: right"]Sum of City Tax Lien[/TD]
[TD="align: right"]Sum of Small Claims Judgement[/TD]
[TD="align: right"]Sum of State Tax Lien[/TD]
[TD="align: right"]Sum of State Tax Warrant[/TD]
[TD="align: right"]Min of Filing Date:[/TD]
[TD="align: right"]Max of Filing Date:[/TD]
[TD="align: right"]Sum of Amount:$[/TD]
[/TR]
[TR]
[TD]CONOCOPHILLIPS CO2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11/13/2006[/TD]
[TD="align: right"]11/13/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]FEDERAL INSURANCE CO OF INDIANA2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2/9/2007[/TD]
[TD="align: right"]2/9/2007[/TD]
[TD="align: right"]$61,022[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTING INC3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/26/1996[/TD]
[TD="align: right"]8/26/1996[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/5/2006[/TD]
[TD="align: right"]4/5/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/11/2006[/TD]
[TD="align: right"]2/15/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/31/2008[/TD]
[TD="align: right"]3/31/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/30/2006[/TD]
[TD="align: right"]6/30/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/5/2006[/TD]
[TD="align: right"]7/5/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1/18/2008[/TD]
[TD="align: right"]1/18/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/5/2008[/TD]
[TD="align: right"]9/8/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC19[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/4/2007[/TD]
[TD="align: right"]4/4/2007[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/11/2007[/TD]
[TD="align: right"]6/11/2007[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC21[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5/2/2008[/TD]
[TD="align: right"]5/2/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC22[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1/21/2005[/TD]
[TD="align: right"]1/21/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC23[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/13/2008[/TD]
[TD="align: right"]3/13/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC24[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/13/2005[/TD]
[TD="align: right"]7/13/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2/6/1996[/TD]
[TD="align: right"]2/6/1996[/TD]
[TD="align: right"]$579[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC26[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/11/1996[/TD]
[TD="align: right"]3/11/1996[/TD]
[TD="align: right"]$381[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC27[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/27/1996[/TD]
[TD="align: right"]3/27/1996[/TD]
[TD="align: right"]$2,432[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC28[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]$6,215[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC29[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/29/2008[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC30[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5/2/2005[/TD]
[TD="align: right"]5/2/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC31[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/31/2010[/TD]
[TD="align: right"]8/31/2010[/TD]
[TD="align: right"]$273[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10/3/2012[/TD]
[TD="align: right"]10/3/2012[/TD]
[TD="align: right"]$17,393[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/5/2003[/TD]
[TD="align: right"]4/28/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11/8/2005[/TD]
[TD="align: right"]11/8/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9/8/2005[/TD]
[TD="align: right"]9/8/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9/21/2005[/TD]
[TD="align: right"]9/21/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]$88,295[/TD]
[/TR]
</tbody>[/TABLE]
've tried all possible ways, sum if, sum product, index an match, etc. but whenever I go back and filter its also picking up the grand total number located in the pivot table.
Therefore in lieu of the correct number (example $17,393) it doubles (example $34,786)
The current formula I'm using to pull the pivot table data into a sheet named "Chart" - Cell Reference (G10)
=SUMPRODUCT(SUBTOTAL(9,OFFSET(DEBTOR!N5,ROW(DEBTOR!N5:N32)-ROW(DEBTOR!N5),,1)),--(DEBTOR!J5:J32>0))
also tried,
=SUMIFS(DEBTOR!$N$5:$N$30,DEBTOR!$J$5:$J$30,">0")
The date in the pivot table (DEBTOR)
[TABLE="class: cms_table, width: 739"]
<tbody>[TR]
[TD]Row Labels[/TD]
[TD="align: right"]Sum of Civil Dismissal[/TD]
[TD="align: right"]Sum of Civil New Filing[/TD]
[TD="align: right"]Sum of Civil Suit[/TD]
[TD="align: right"]Sum of Judgements[/TD]
[TD="align: right"]Sum of Chapter 7[/TD]
[TD="align: right"]Sum of Federal Tax Lien[/TD]
[TD="align: right"]Sum of City Tax Lien[/TD]
[TD="align: right"]Sum of Small Claims Judgement[/TD]
[TD="align: right"]Sum of State Tax Lien[/TD]
[TD="align: right"]Sum of State Tax Warrant[/TD]
[TD="align: right"]Min of Filing Date:[/TD]
[TD="align: right"]Max of Filing Date:[/TD]
[TD="align: right"]Sum of Amount:$[/TD]
[/TR]
[TR]
[TD]CONOCOPHILLIPS CO2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11/13/2006[/TD]
[TD="align: right"]11/13/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]FEDERAL INSURANCE CO OF INDIANA2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2/9/2007[/TD]
[TD="align: right"]2/9/2007[/TD]
[TD="align: right"]$61,022[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTING INC3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/26/1996[/TD]
[TD="align: right"]8/26/1996[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/5/2006[/TD]
[TD="align: right"]4/5/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC11[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/11/2006[/TD]
[TD="align: right"]2/15/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC13[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/31/2008[/TD]
[TD="align: right"]3/31/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC14[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/30/2006[/TD]
[TD="align: right"]6/30/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC15[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/5/2006[/TD]
[TD="align: right"]7/5/2006[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC16[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1/18/2008[/TD]
[TD="align: right"]1/18/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC17[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/5/2008[/TD]
[TD="align: right"]9/8/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC19[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/4/2007[/TD]
[TD="align: right"]4/4/2007[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]6/11/2007[/TD]
[TD="align: right"]6/11/2007[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC21[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5/2/2008[/TD]
[TD="align: right"]5/2/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC22[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1/21/2005[/TD]
[TD="align: right"]1/21/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC23[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/13/2008[/TD]
[TD="align: right"]3/13/2008[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC24[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/13/2005[/TD]
[TD="align: right"]7/13/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC25[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2/6/1996[/TD]
[TD="align: right"]2/6/1996[/TD]
[TD="align: right"]$579[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC26[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/11/1996[/TD]
[TD="align: right"]3/11/1996[/TD]
[TD="align: right"]$381[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC27[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3/27/1996[/TD]
[TD="align: right"]3/27/1996[/TD]
[TD="align: right"]$2,432[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC28[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]$6,215[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC29[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4/29/2008[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC30[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]5/2/2005[/TD]
[TD="align: right"]5/2/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC31[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/31/2010[/TD]
[TD="align: right"]8/31/2010[/TD]
[TD="align: right"]$273[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]10/3/2012[/TD]
[TD="align: right"]10/3/2012[/TD]
[TD="align: right"]$17,393[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC5[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]8/5/2003[/TD]
[TD="align: right"]4/28/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]11/8/2005[/TD]
[TD="align: right"]11/8/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9/8/2005[/TD]
[TD="align: right"]9/8/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]PERFORMANCE CONTRACTORS INC9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]9/21/2005[/TD]
[TD="align: right"]9/21/2005[/TD]
[TD="align: right"]$0[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]7/18/1995[/TD]
[TD="align: right"]5/30/2013[/TD]
[TD="align: right"]$88,295[/TD]
[/TR]
</tbody>[/TABLE]
