Sumifs Array Help

[dmarzean]

I have the following that I have been using on a commission payroll sheet. problem is, there have been some changes and I now need to sum instead of count due to negative values being added to the data sheet.

=IF(COUNTIFS('Work Orders'!$B$2:$B$9987,"=" &[@[Work Order]],'Work Orders'!$I$2:$I$9987,">-2",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]])>0,COUNTIFS('Work Orders'!$B$2:$B$9987,"=" & [@[Work Order]],'Work Orders'!$I$2:$I$9987,">-2",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]]),"")

Here is the spreadsheet http://integsalesjobs.com/wp-content/uploads/2014/01/01-14-az-PAYROLL.xlsm

 

[Rijnsent]

Okay, I think I get it:
=IF(COUNTIFS('Work Orders'!$B$2:$B$9987,"=" &[@[Work Order]],'Work Orders'!$I$2:$I$9987,">-2",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]])>0,COUNTIFS('Work Orders'!$B$2:$B$9987,"=" & [@[Work Order]],'Work Orders'!$I$2:$I$9987,">-2",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]]),"")

Would be:
=IF(SUMIFS('Work Orders'!G$2:G$9987,'Work Orders'!$B$2:$B$9987,"=" &[@[Work Order]],'Work Orders'!$G$2:$G$9987,">0",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]])>0,COUNTIFS('Work Orders'!$B$2:$B$9987,"=" & [@[Work Order]],'Work Orders'!$G$2:$G$9987,">0",'Work Orders'!$E$2:$E$9987,"=" &[@[Last Name]]),"")

So basically the only thing that changes is: COUNTIFS -> SUMIFS, and just after SUMIFS( you have to insert what you'd like to sum, in this case: SUMIFS('Work Orders'!G$2:G$9987, (assuming that's TV Starter).

Good luck