Thread: Help with a SUMPRODUCT Formula
View Single Post
 
Old 05-15-2017, 08:03 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Does this array formula work?

=SUM((NETWORKDAYS(IF(D1>$B$3:$B$11,D1,B3:B11),IF(E OMONTH(D1,0)<C3:C11,EOMONTH(D1,0),$C$3:$C$11))))

Confirmed with CTRL+SHIFT+ENTER not just ENTER
Reply With Quote