Try
=SUMPRODUCT(--(YEAR(Record!C4:Record!C30)=2012),--(MONTH(Record!C4:Record!C30)=1),--(Record!D4:Record!D30-Record!C4:Record!C30<=14),--(Record!B4:Record!B30=1))
Try
=SUMPRODUCT(--(YEAR(Record!C4:Record!C30)=2012),--(MONTH(Record!C4:Record!C30)=1),--(Record!D4:Record!D30-Record!C4:Record!C30<=14),--(Record!B4:Record!B30=1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks