Hello,
I need a formula or code for "sumproduct" by looking between date range for two worksheets.
I have got the formula below which is working perfect within same Sheet1. The formula is
=SUMPRODUCT(($C$8:$C$16>DATE(2013,6,31))*($C$8:$C$16<DATE(2013,12,31))*($B$8:$B$16))
But I need a formula that takes the sum from Sheet2 and show it in Sheet1.
I hope you guys will be understanding what I mean..
Thanks in advance
Reagards
z-eighty2
Bookmarks