Using NETWORKDAYS within SUMIF?

[cshoultz]

I have a large spreadsheet for tracking sales and installation of what is sold. Sheet 1 is a Dashboard. Sheet 2 contains each sales record with the corresponding sales and installation activity. Column H (named range SignedDateRec) contains the contract signed date. Column J (Named range SchedDateRec) contains the date the installation is scheduled to be done. The install team has 3 business days to schedule the installation. I need a field on the dashboard that indicates how many sales have not been scheduled yet and are beyond the 3 day threshold. I'm trying to use SUMIFS along with NETWORKDAYS but am having problems and am open to other ideas to achieve the goal in mind.

Assuming today is 12/24/15, the dashboard would show a value of 1 as the record for 12/9 is not yet scheduled and should have been.

The formula I'm trying to use looks like: =SUMIFS(DataPSUs,SchedDateRec,"",SignedDateRec,NETWORKDAYS(SignedDateRec,TODAY()>3))

The array DataPSUs simply holds a 1 if this is the type of record that needs to be counted or is blank otherwise. In this example, assume every record shown has a 1 for the DataPSUs value.[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]Signed Date[/TD]
[TD]Construction PCD[/TD]
[TD]Scheduled Installation Date[/TD]
[/TR]
[TR]
[TD]12/2/15[/TD]
[TD][/TD]
[TD]1/16/16[/TD]
[/TR]
[TR]
[TD]12/9/15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/12/15[/TD]
[TD][/TD]
[TD]12/19/15[/TD]
[/TR]
[TR]
[TD]12/23/15[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[yky]

Is the "" in the formula for blank cells? If so, try "<>".

 

[cshoultz]

The "" is for blank cells. I tried "<>" without success.

 

[yky]

Don't know how to do it with SUMIFS. The following array formula works for the example you posted. It gives 2, assuming b2:b5 is full of 1's and 1 when I change the last date to December 31, 2015 (tested on Jan. 2nd 2016). Need to enter the formula with Ctrl-Shift-Enter. Hope someone can make it work with SUMIFS.

=SUM(IF(NETWORKDAYS(A2:A5+0,TODAY())>3,B2:B5,0)*IF(LEN(C2:C5)=0,B2:B5,0))