LinkBack URL
About LinkBacks
Try this in D2 filled down.Formula:
=SUMPRODUCT(($B2<=Payroll!$D$2:$D$27)*($C2>=Payroll!$C$2:$C$27))
Edit You almost had it. The references just needed to be crossed.
Try this in D2 filled down.Formula:=SUMPRODUCT(($B2<=Payroll!$D$2:$D$27)*($C2>=Payroll!$C$2:$C$27))
Edit You almost had it. The references just needed to be crossed.
Last edited by FlameRetired; 12-31-2015 at 12:40 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks